Subcategories

Hi Benjamin,

This is an interesting question! Currently, our pie chart visualization only accepts 1 dimension and 1 measure so this type of hierarchy isn’t possible in a single pie chart. I will definitely pass your feedback to the product team though – were you thinking of something along the lines of a pivoting on the subcategory and seeing those represented as sub “slivers” of similar/the same shades as the parent category?

You may be able to get close to your desired effect by placing two pie chart visualizations next to each other on a dashboard and use custom coloring of the slices to help users map the subcategories to their parent category visually. You could also pivot on the subcategories and select a stacked column visualization where the three bars are the main categories (meat, vegetables, fruit) and each is made up of their subcategories in a stack.

I hope that helps!

Thanks for that link to the visualization, I like that a lot! @jakeyoos and I were talking about this and he suggested this discourse post might be a helpful approach to giving users another layer of drill down. The dashboard example uses a simple pie chart that defaults to a main category which also has a dashboard filter that manipulates the pie chart and associated metrics.

Users can input one of the main categories from the pie chart and the tiles will update to show the subcategory details. In your case the pie chart would default to meat, fruit, vegetables with a relevant chart of some kind, then when a user picks “meat” in the dashboard filter, that pie chart would update with bacon, turkey, and beef.

You all are the best!!! I will share with our analysts and see what we can implement. Thank you. 🙌

@bgadbaw Womp indeed. We usually recommend using buckets to get below 50 rows in that case. But of course, in this example, you already have buckets and you just want to show the subcategory breakdown.

I’ll pass this along to our product team. There isn’t a way around that 50 row limit, but I suppose you could do subcategory drilling or make a dashboard with a tile for each subcategory.

The link doesn’t seem to be working, but that looks like a stellar set up!! Would love to learn how that was accomplished, we have hierarchies galore.