Custom Decomposition Tree

[nataliesmiy1357]

Hello!  I am wanting to create a decomposition tree that can break down two different things.

I have the columns; External Downtime, Internal Downtime, Plant and Line, Date Total Downtime.

I am wanting to have a breakdown of the Total Downtime --> External and Internal downtime.  Then, I want to breakdown the top of both of those downtimes by which plant they are being impacted to.  

Something like this - but then I can break the plant into two different columns

Please note that External + Internal = Total Downtime.

[Anonymous]

Hi @nataliesmiy1357 ,

I create a table as you mentioned.

Then I select Dcomposition Tree and put columns into it.

Here you can click on Product Category and it will show you Region.

If you want to show all of them ,you can open Show All.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

You mean a Sankey Chart visual?

[nataliesmiy1357]

No - I still want a decomposition tree - but I want 2 items to start it off instead of 1... so ex) I want to pick Continents as my starting value - and then it shows all 7, then I can drill into those.

[lbendlin]

You need to unpivot your source data to convert columns into rows.