Module 3 Visual Analytics with Tableau Table Calculations

ByAdmin September 8, 2021

Module 3 Visual Analytics with Tableau Table Calculations >>> Visual Analytics with Tableau

Table calculations allow you to filter your data for a specific view

Table calculations are not allowed to be performed in Tableau

Table calculations address data in the cache table and allow you to perform calculations on visible results

————————————————————————————————

Table calculations are used to create new calculations

Table calculations are used to give fields new names

Table calculations are used to view summary data

————————————————————————————————

A calculated field is every field in your data set

A calculated field is a field that is present in your original data set

A calculated field is a new field that is not in the current data set

————————————————————————————————

Right click anywhere in the data pane and select Create Calculated Field

Right click anywhere in the data pane and select Create Parameter

Right click anywhere on your chart and select Create Calculated Field

————————————————————————————————

Rank

Running Total

Month over Month Difference

Difference

Percent of Total

Percent Difference

MTD Total

————————————————————————————————

To provide additional data that may not be present in your chart

To create a new calculation that is not in the current data set

To narrow down your data table or chart to specific fields and/or data

————————————————————————————————

Drag a dimension or measure to the filter data pane

Drag a dimension or measure to the size option on the Marks card

Drag a dimension or measure to the color option on the Marks card

————————————————————————————————

Right click anywhere in the data pane and select show filter

Right click on your filter pill and select show filter

Right click in your worksheet and click show filter

————————————————————————————————

Parameters are filters

Parameters are constant values that can replace dynamic values in calculations, filters, and reference lines

Parameters are dynamic values that can replace constant values in calculations, filters, and reference lines