I am working on a visualization of the availability of products for each car model in the world and I would like to use the sunburst chart to navigate through that heterarchical data.
The columns of my data frame are the following: [‘Region’, ‘Country’, ‘Brand’, ‘Model’, ‘Type’, ‘Seats’, ‘Doors’, ‘Transmission’, ‘Fuel Type’, ‘Volume’, ‘Coverage’, ‘color’]
The important column is the “coverage” column in %, which means basically how many products are available for that particular model in %. 100% means all products for that car are available.
What I would like to do is one of two things:
1: Using the path below, but having the root and branches to show the average of the leafs. p.e. Audi would show the average of the coverage of all its models, and the country Spain would show the average of the % of all the brands in that country, and so on. I would assume that in this case the size of each slice is proportional to that calculated average %
2: The second option would be to multiply the volume (amount of vehicles) times the % of coverage to get the size of the slices. BUT the labels of each slice should still be the aggregated average of coverage in %.
How can I configure the sunburst chart to get those results?