From the course: Tableau 10: Mastering Calculations
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Summarize data within a defined window of rows - Tableau Tutorial
From the course: Tableau 10: Mastering Calculations
Summarize data within a defined window of rows
- [Instructor] Many calculations look at every row of a table, while others look at either all previous rows or a subset of the previous rows. In this movie, I will show you how to create calculations that can look at a window of rows. That can include rows before the current one, or after the current one, or a combination of both. The window calculations, which you can use in the manner I've described, include a number of very familiar names. And in fact, these are all variations on the base functions that I described elsewhere in the course. You can, for example, find the sum average or count of the number of rows within a window. You can find the minimum, maximum, and median value, the variance or variance for the entire population. Same thing for a standard deviation. And again, as a reminder, most professional analysts never use the population versions of those calculations, they just use the variance or standard deviation. And you can also look for a percentile rank based on a…
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
-
-
-
-
-
-
-
-
-
Create a quick table calculation3m 46s
-
Calculate a running total or moving average6m 5s
-
Add a secondary table calculation4m 25s
-
Rank table data3m 54s
-
Identify a table row using INDEX2m 3s
-
Count table rows from first or last row3m 40s
-
Look up values using PREVIOUS_VALUE and LOOKUP5m 43s
-
Return the number of rows in the partition3m 50s
-
Summarize data within a defined window of rows5m 49s
-
-
-