Relative percentage calculation issue

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 want to get below output from above

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

Hey @gauravkumar ,

maybe you could share a picture of your problem and how it looks right know vs. how you want it to look. I have problems understanding you Use-Case and how to approach it without an underlying dataset.


Hi @gauravkumar. Checking in. We have not heard back from you regarding your question. We’d still like to help. If we do not hear back in the next 3 days, we will archive the question.