Relative percentage calculation issue

[ankit_tikoo]

Hi Guys,

I have a problem statement for all. I am from payment industry. Let me explain my problem

Day  Failure/success reason    Txn_Count

1        No funds                           10

1       Cancelled                           20

1        Not approved  by bank      30

1        Successful                         40

Total                                            100

I have put a condition in the expression(Txn_Count) formula that Status='failed' to get below:

Day  Failure/success reason   Txn_count

1        No funds                           10

1       Cancelled                           20

1        Not approved                     30

I want count to be a relative percent i.e 10% for no funds, 20% for cancelled and 30% for not approved. This percent should be calculated with denominator 100 not 60

Also, This is for only on day. If there are many days and I select No funds failure reason, it should show relative share for all individual days.

1   No Funds   40%

2   No Funds  20%

3   No Funds  10%

Right now its showing 100% for all days. Can anyone help here

[ankit_tikoo]

Thanks!!

On more thing - In the table, when I click on a specific failure reason, then it shows 100% for all days. It should show the %share of that selected failure reason for all days. Can you suggest any solution.

[sunny_talwar]

Not sure what your selection requirements are (meaning what selection should filter the percentage and which one should not), but try like this if you want to keep the percentages same for all possible selections

Sum({<Status = {'Failed' }>}Txn_count) /Sum(TOTAL <Day> {1} Txn_count)