Fixing Tableau Calculation Aggregation Errors
Vložit
- čas přidán 4. 08. 2024
- Connect with us:
•Upcoming Tableau Classes: onenumber.biz/onenumber-table...
•Book an hour to work with Ollie: www.eventbrite.com/e/tableau-...
•Subscribe to the OneNumber Newsletter: onenumber.biz/newsletter
•Follow Ollie Linley on LinkedIn: / oliverlinley
Description:
Have you ever seen the error: “Cannot mix aggregate and non-aggregate arguments in this function?” If you’ve worked with Tableau for any period of time, you probably have! You could have seen this in an IF statement, a CASE statement, or just a regular calculation!
The big idea is that we can’t aggregate part of our calculated field while not aggregating another part of the same calculated field.
This is because aggregated functions run at a "summary" level, while a non-aggregated function runs at a “row by row” level. So, when we try to use these in one function, Tableau gets confused at exactly how to execute what we’re asking!
Want to fix those pesky calculations with aggregation errors? I’ll walk you through troubleshooting those in this video!
Resources:
•Example Tableau Workbook: public.tableau.com/views/Aggr...
•Why Aggregations Are Important in Tableau Calculations: onenumber.biz/blog-1/2022/12/...
•Cannot mix aggregate and non-aggregate comparisons or results in ‘IF’ expressions blog post: onenumber.biz/blog-1/2018/1/3...
Chapters:
0:00 Examples of Aggregation Errors
1:10 How Aggregations Work
4:00 Fixing General Aggregation Errors
4:45 Fixing Aggregation Errors in IF Statements
7:00 Fixing Aggregation Errors in CASE Statements
7:48 Upcoming Tableau Classes
8:26 Fixing Aggregation Errors in CASE Statements
Need help with your Tableau calculations? Schedule an hour with Ollie! www.eventbrite.com/e/tableau-office-hours-with-ollie-linley-eastern-time-tickets-439769641837 | Ready to master Tableau? Check out our lineup of upcoming classes! www.eventbrite.com/o/onenumber-15678294163
This might be a very simple topic but it is often something that is misunderstood especially by newcomers.
The explanation was superb and thanks for all your efforts!!!
Thank you so much for the kind words!
Excellent explanation. Aggregation errors give me headaches.
Thank you! We're glad this is helpful and clear!
Very helpful
We're glad it helped, thank you!
What if we are using the date column along with the aggreated column in one calculation?
At that time Sum of date cannot be right.. Can you please help me on this to overcome?
Our aggregated fields can be sliced up by whatever dimension is in our view. So, If you have SUM(Sales) with a Date column, then it will calculate the SUM(Sales) for each Date value in the view. So we wouldn't SUM a Date field, but rather SUM a measure. Does that help?