Exercise: row level, aggregate level, table level

Let us look at the following steps and begin our exercise:

  1. In the workbook associated with this chapter, navigate to the Row_Agg_Tbl worksheet.
  2. Select Analysis > Create Calculated Field to create the following calculated fields. Note that each must be created separately, that is, it isn't possible in this context to create a single calculated field that contains all three calculations:

Name

Calculation

Lev  Row

[Number of Records]/[Quantity]

Lev  Agg

SUM ([Number of Records])/SUM (Quantity)

Lev  Tab

WINDOW_AVG ([Lev - Agg])

  1. In the Data pane, right-click on the three calculated fields you just created and select Default Properties | Number format.
  2. In the resulting ...

Get Mastering Tableau 2019.1 - Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.