We can also create a more advanced version of the Pareto chart that shows the actual 80% and 20% values. We can start with the simple version created in the previous steps, and use the advanced worksheet to see the end product, by taking the following steps.
- Add Emission Type to the Detail section of the Marks card. We do this because our table calculation for Sum(Value) is referencing a specific dimension Emission Type, as follows:
- On the Columns shelf, modify Emission Type to be a Count (Distinct), as follows:
- Apply ...
