Exercise steps part II – solving without an LOD calculation

Follow along the exercise steps:

  1. In a new worksheet, create a calculated field named Window_AVG with the following code:

WINDOW_AVG(SUM([Sales]))

  1. Place Region on the Columns shelf, Sales on the Rows shelf, and Window Avg on the Rows shelf.
  2. Select the Window Avg pane in the Marks View Card and add State to the Detail shelf.
  1. Right-click on Window Avg and select Compute Using > State.
  2. Select the Window Avg pane in the Marks View card and select Gantt Bar as the view type:

  1. Adjust the color of the Gantt Bar to contrast with the bar chart associated with SUM(Sales).
  2. Right-click on ...

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.