Forum Discussion
Format data split in several columns for a Doughnut chart
Solution SageHi Marcus_swe ,
According to your description, my understanding is that you want to create a drilldown with the order: Deparment -> Salesperson -> Part No.
In this scenario, we can create a Hierarchy for them by draging these items to Deparment like below:
Then we can use the Deparment Hierarchy as Legend in Donut chart. But I would suggest you using the Clustered Bar chart, it will can display the detail when we drilldown.
Best Regards,
Teige
Hi TeigeGao
Thank you for the reply and the gifs. Very educational.
You are assuming correct regarding the drilldown order.
I get the drilldown and hierarchy to work as you show. But I can only get it to work with one chart per deviation type.
Where i get stuck is IF it is possible use one chart with the setup on the picture below.
Kind Regards Marcus
tangutooriHelper III
hi my wotk for above query.
Marcus_swe wrote:Hi TeigeGao
Thank you for the reply and the gifs. Very educational.
You are assuming correct regarding the drilldown order.
I get the drilldown and hierarchy to work as you show. But I can only get it to work with one chart per deviation type.
Where i get stuck is IF it is possible use one chart with the setup on the picture below.
Kind Regards Marcus
Marcus_swe wrote:Hi TeigeGao
Thank you for the reply and the gifs. Very educational.
You are assuming correct regarding the drilldown order.
I get the drilldown and hierarchy to work as you show. But I can only get it to work with one chart per deviation type.
Where i get stuck is IF it is possible use one chart with the setup on the picture below.
Kind Regards Marcus