From the course: Tableau 10: Mastering Calculations
Unlock the full course today
Join today to access over 22,700 courses taught by industry experts or purchase this course individually.
Look up values using PREVIOUS_VALUE and LOOKUP - Tableau Tutorial
From the course: Tableau 10: Mastering Calculations
Look up values using PREVIOUS_VALUE and LOOKUP
- [Instructor] In business, it's often important to compare value such as a month's sales to the previous value from that dataset. You can create a table calculation to do that using the previous value function. If you want to look up other values such as those two or three table rows away, you can use the lookup function and specify the distance you want to move. In this movie, I will show you how to create these table calculations. My sample file is the previous workbook, and you can find it in the chapter 7 folder of the exercise folders collection. I have monthly order total data for my hotel which orders supplies, and what I want to do is to determine the difference between one row, in this case February of 2015 and the previous row. To do that, I can create my table calculation so I'll go to the marks card, hover the mouse pointer over the order total pill, click the down arrow, and click Add Table Calculation. The table calculation dialog box appears, and I want to find the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
-
(Locked)
Create a quick table calculation3m 46s
-
(Locked)
Calculate a running total or moving average6m 5s
-
(Locked)
Add a secondary table calculation4m 25s
-
(Locked)
Rank table data3m 54s
-
(Locked)
Identify a table row using INDEX2m 3s
-
(Locked)
Count table rows from first or last row3m 40s
-
(Locked)
Look up values using PREVIOUS_VALUE and LOOKUP5m 43s
-
(Locked)
Return the number of rows in the partition3m 50s
-
(Locked)
Summarize data within a defined window of rows5m 49s
-
(Locked)
-
-