Forum Discussion

surendar12's avatar
surendar12
Regular Visitor
6 years ago

Decomposition Tree - Use Case

Hi All,     Decomposition tree is powerful and I have a use case that I would like to use for the repot.    What I have is a classic funnel and I would like to use as tree . Reason is because the...
Need Help
surendar12's avatar
surendar12
Regular Visitor
6 years ago

amitchandak  it is step2/step1 , step 3/ step 1, step4/step1

 

 

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Not clear but something like this

    step 1 =calculate(countrows(Table1),allexcept(table1,table[path1]))
    only step 2 =calculate(countrows(Table1))

    Ratio = calculate([only step 2 ]/step 1)

    step 2 =calculate(countrows(Table1),allexcept(table1,table[path2]))