Why Aggregations Are Important in Tableau Calculations
Вставка
- Опубліковано 8 лип 2024
- Connect with us:
•Upcoming Tableau Classes: www.eventbrite.com/o/onenumbe...
•Book an Office Hour with Eric: www.eventbrite.com/e/tableau-...
•Subscribe to the OneNumber Newsletter: 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: public.tableau.com/app/profil...
•Data Source: data.world/ericparker/grocery...
•Tableau Calculation Aggregation Errors: 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
Need help with your own aggregated calculations in Tableau? Book an office hour with Eric to work on it together: www.eventbrite.com/e/tableau-office-hours-with-eric-parker-tickets-42691995909
Can we find ratio of two measurement as an example
Ratio of male to female is 3:2
Ratio of Yes to No response is 4:3
Is it possible in Tableau?
So you are saying you'd rather display the ratio as 3:2 instead of just 1.5?
@@onenumbertableau yup exactly, would like to display the ratio not a decimal value , it can be done in excel but in tableau it seems impossible
@@skyful9 I've never seen it done in Tableau and I don't believe the capability is native. You might find this forum discussion and example calculation helpful: community.tableau.com/s/question/0D54T00000C6HLFSA3/ratio-display
@@onenumbertableau Thank You.