How to add Percentage of the total transactions in a dashboard

[sebasy2k]

Good afternoon,

We need to add a column to the following window with the specific transactions (grouped by Response code) percentage of the total transactions. In the red box I represented an example of the need:

The data view definition is combined by ResponseCode. Is there a way to add the percentage of the total trx in a new column?

Thank you in advance!

[David_Sun]

Hi @sebasy2k ,

Adding a new column in the display usually requires a User Defined Field to be configured in the display document. The new field can perform calculation to show the desired output. Our support team will work with you on the specific requirement in the support case. Thanks

[ChristopherS]

This is what we typically utilize in the User Field:

You can edit the bolded portion to use different records.

=re("B24EPS.APRV%","(\d+).*")? $1 + "% (B24EPS.APRVCNT/B24EPS.TRANCNT)" : "(B24EPS.APRVCNT/B24EPS.TRANCNT)"

[sebasy2k]

Hi Chris, thank you for your response.

Probably I didn't explain myself well. We need this:

The percentage per line should be composed by:

Specific Response Code transactions / Total transactions (sum of all the Response Code transactions)

So, if you see the example image, the sum of all transactions under “Trx” column is “423” (223+62+49+31+19+…), and the Specific Response Code transactions (Combined by Response Code & Response From) is “223” (in the first line example), so the percentage in first line should be 53% (223/423), in the second line 15% (62/423), in the third line 12% (49/423), and so on.

BTW, we already have an open case with the support.

Thank you!

[ChristopherS]

This is not currently possible in a user way without using a Services Toolset and putting the information into a new record.  There are multiple RFEs open for this already for product to this.. I suggest you reach out to your account team to get an RFE in or discussing services doing it near term.

See Picture Below which is our understanding of the ask beyond what I originally posted.