Fixing Tableau Calculation Aggregation Errors

[@onenumbertableau]

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

[@equiwave80]

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!!!

[@onenumbertableau]

Thank you so much for the kind words!

[@scottstewart3779]

Excellent explanation. Aggregation errors give me headaches.

[@onenumbertableau]

Thank you! We're glad this is helpful and clear!

[@zohebakber9088]

Very helpful

[@onenumbertableau]

We're glad it helped, thank you!

[@shrinithiv5906]

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?

[@onenumbertableau]

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?