Tableau Desktop Certified Associate: Exam Guide

Example 2 – contributions

Using the Global Superstore dataset, we want to see the contribution of units ordered by country in the LATAM market, against both that region only and the whole company.

The list of dimensions in the FIXED syntax is optional. We can therefore define Total Quantity as {FIXED:SUM([Quantity])}. This will be the equivalent of having a quantity that is equal to the total units for each calculation. This will be a value that will never change regardless of the level of aggregation of our view.

We can then define Worldwide Qty Contribution as SUM([Quantity]) / ATTR([Total Quantity]) (as Total Quantity needs no aggregation).

Here, we use ATTR, because otherwise we would get an error due to mixing aggregates and non-aggregates. ...