Forum Discussion

nataliesmiy1357's avatar
nataliesmiy1357
Helper IV
1 year ago

Custom Decomposition Tree

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.

Need Help
Show and Tell

4 Replies

    • nataliesmiy1357's avatar
      nataliesmiy1357
      Helper IV
      1 year ago

      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's avatar
        lbendlin
        Super User
        1 year ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.