From the course: Tableau 10: Mastering Calculations
Unlock this course with a free trial
Join today to access over 25,300 courses taught by industry experts.
Calculate a running total or moving average - Tableau Tutorial
From the course: Tableau 10: Mastering Calculations
Calculate a running total or moving average
- [Narrator] The data that you capture shows how business operations progress over time. All results for individual months or years are important. You might also want to see running totals and averages that show accumulated sales or costs over time. In this movie, I'll show you how to create those table calculations to find the average count, minimum, maximum, and sum of values as you go along. My sample file is the Running workbook, and you can find it in the Chapter07 folder of the Exercise Files collection. In this visualization, I have monthly order data broken down by five product categories. Currently I just have the data by itself, but let's say that I want to create a calculated field that would find either running totals or running averages and so on. To do that, I'd go to the Analysis menu, and click Create Calculated Field, and here I'm going to use the same field and edit it several times. I'll just call it…
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)
-
-