Lookup and Total

The objectives of the following worksheet displays those customers who made purchases in the last 2 days of 2013, and the associated absolute as well as relative sales of the month of December.

In the following table, notice in the results how LOOKUP behaves directional whereas TOTAL is non-directional. Follow the steps in order to do so:

  1. In the workbook associated with this chapter, navigate to the Lookup/Total worksheet.
  2. Drag Customer Name and Order Date to the Rows shelf. Set Order Date to Month/Day/Year discrete.
  3. Place Order Date on the Filters shelf and choose to view only December 2013.
  4. Create the following calculated fields:

Name

Calculation

Lookup Intervening Time

DATEDIFF(day,LOOKUP(Max([Order Date]),0), ...

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.