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

Summarize data within a defined window of rows - Tableau Tutorial

From the course: Tableau 10: Mastering Calculations

Start my 1-month free trial

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…

Contents