How to color a Pictogram with more than two categorical columns
By default, the Pictogram template will color each icon according to the column bound under Color in the Data tab. However, this will only work if the specified column is also bound under either Main category or Subcategory.
But what if we have more than two categorical columns? Let's take a look at the example below.
In this visualization, we have various authors who received a best debut/first novel award. We want to represent the female authors with a female icon and the male authors with a male icon .
We also want to split them by age group. Therefore, we would need two columns – one for Gender and another one for Age.
Our Age column will be our Main category because we would like to define different age categories along the main axis. However, under Subcategory, we can either put Gender or Nationality.
If we bind the Gender column under Subcategory, that would mean that we wouldn't be able to color by Nationality. This is because, under Icon ID and Color, we can only use columns that have already been bound under Main- or Subcategory.