Unit charts, also referred to as pictogram charts, display each unit of measure as a single mark or symbol. While other types of charts may be more effective and less cluttered, unit charts may create more engagement because of the images and visuals used.
In this recipe, we will create a unit chart that shows all the medals that were won by Canada in the Summer Olympics from 1896-2008.
To follow this recipe, open B05527_02 – STARTER.twbx. Use the worksheet called Unit Chart, and connect to the ALL MEDALISTS (Summer_Olympic_medallists_1896-2008) data source.
The following are the steps to create a unit chart:
From Dimensions, drag NOC to the Filters shelf and filter to CAN.
From Dimensions, drag Edition to Rows.
From Dimensions, drag City to Rows, to the right of Edition.
Create a calculated field called # of Medals. This field should be fixed to Edition and NOC so that it is not affected by the data fields (pills) used in the view.
From Dimensions...
