Why Aggregations Are Important in Tableau Calculations
Connect with us:
•Upcoming Tableau Classes: https://www.eventbrite.com/o/onenumbe...
•Book an Office Hour with Eric: https://www.eventbrite.com/e/tableau-...
•Subscribe to the OneNumber Newsletter: https://onenumber.biz/newsletter
•Follow Eric on LinkedIn: / eric-parker-37513249
Description:
Aggregations are functions which allow you to consolidate numerous rows of values into a single output. SUM, AVG, MIN, MAX, COUNT and COUNTD are some of the most used aggregations in Tableau.
Aggregations play an important role in Tableau calculations. If they aren't used properly, calculations will return incorrect results!
If you are writing formulas to calculate ratios, percentages or time period comparisons, it's very likely that you need to incorporate aggregations to return correct outputs.
Ready to see aggregations in Tableau calculations in action? Check out this video!
Resources
•Tableau Workbook: https://public.tableau.com/app/profil...
•Data Source: https://data.world/ericparker/grocery...
•Tableau Calculation Aggregation Errors: https://onenumber.biz/blog-1/2018/1/3...
Chapters:
0:00 What are aggregations?
0:52 Aggregation Calculation Use Cases
1:43 Data Source Example
2:50 Row-Level Calculation Example
7:40 Aggregated Calculation Example
8:40 Switching Between Row-Level and Aggregated Calculations
9:30 Aggregation Calculation Flexibility
10:45 Aggregations for Time Period Comparisons
