Tableau - Table Calculations


Advertisements

These are the calculations which are applied to the values in the entire table. For example, for calculating a running total or running average, we need to apply a single method of calculation to an entire column. Such calculations cannot be performed on some selected rows.

Table has a feature called Quick Table Calculation, which is used to create such calculations. The steps to be applied in Quick Table calculation are as follows −

Step 1 − Select the measure on which the table calculation has to be applied and drag it to column shelf.

Step 2 − Right-click the measure and choose the option Quick Table Calculation.

Step 3 − Choose one of the following options to be applied on the measure.

  • Running Total
  • Difference
  • Percent Difference
  • Percent of Total
  • Rank
  • Percentile
  • Moving Average
  • Year to Date (YTD) Total
  • Compound Growth Rate
  • Year over Year Growth
  • Year to Date (YTD) Growth

Example

Let’s calculate the running total of the profits earned for the data source following the above steps. Use the data source named sample – superstore.xls.

Useful Video Courses


Video

Tableau Online Training

Best Seller

88 Lectures 10 hours

Pavan Lalwani

Video

49 Charts in Tableau - (Latest Version)

64 Lectures 4 hours

Pavan Lalwani

Video

Visualising Data using Tableau

18 Lectures 1 hours

PARTHA MAJUMDAR

Video

Tableau Hands-on: Learn Data Visualization with Tableau

45 Lectures 5.5 hours

TELCOMA Global

Video

Master Data Visualization with Tableau

14 Lectures 53 mins

Harshit Srivastava

Video

Learn data visualization by tableau

40 Lectures 3.5 hours

Sanjeev

Advertisements