Tidbits
Here are a few tidbits/tricks that you may find helpful as you venture into the world of calculated fields in Tableau (Conversion error):
Cannot mix aggregate and non-aggregate arguments
One of the most common calculation errors you may encounter will be related to mixing aggregate and non-aggregate arguments in functions:
What this simply states is that if one part of the calculation is an aggregation (such as SUM, AVG, MAX, and MIN), all other parts should also be aggregations.
This becomes tricky when working with level of detail calculations. For example, we may have an LOD expression that gets a FIXED sum of sales:
What if we need to use ...
Get Tableau 10 Business Intelligence Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
