Create donut charts/tree maps from data in a different arrangement
I want more flexibility when it comes to creating charts that show proportional representation. Much of the data from the UK Census for example gives each category as an individual field which Insights does not know how to handle. If I were to transform the data to a format that Insights would understand (a row/entry for each individual record) then this would make my dataset absolutely enormous.
To illustrate what I mean a bit better I've attached a picture. The UK Census 2021 has data on population split down by 5 year age bands. I want to show that in a donut chart or tree map so that the user can easily see the distribution of ages within the population, and use the chart to filter to see where the most populous areas are for an age range that they are interested in. In the attached picture you will see the way that the data is set out. Insights would require one field with a string entry stating the age band each individual falls within to create a donut chart/treemap. This would mean that the data table would have to have the same amount of rows as the population of England and Wales, and then multiply that by X if you want to put additional proportional charts in the same dataset. I think that if Insights were configured to accept data like in the picture below as well it would open up a huge amount of new analytical possibilities.
