cancel
Showing results for 
Search instead for 
Did you mean: 

How to add Percentage of the total transactions in a dashboard

sebasy2k
05 Base Camper

How to add Percentage of the total transactions in a dashboard

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:

 

Percentage.JPG

 

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!

4 REPLIES 4
David_Sun
Expert

Re: How to add Percentage of the total transactions in a dashboard

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
12 Sherpa

Re: How to add Percentage of the total transactions in a dashboard

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)"


If my answer helped you today, please be sure to mark the resolved button to assist others.

Christopher R Souser - Solution Architect – MSci. PA, CISSP, ITIL.
sebasy2k
05 Base Camper

Re: How to add Percentage of the total transactions in a dashboard

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
12 Sherpa

Re: How to add Percentage of the total transactions in a dashboard

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.

 

image.png


If my answer helped you today, please be sure to mark the resolved button to assist others.

Christopher R Souser - Solution Architect – MSci. PA, CISSP, ITIL.
Webinar: Keep the modern workforce connected

Unified Communications has always been an important part of companies' digital transformation efforts due to its ability to enable rich virtual collaboration and communication. But with COVID-19, we've reached a break-through point.

Join Bill Haskins, Sr. Analyst & Partner, Unified Communications at Wainhouse Research, and John Ruthven, CEO at IR discuss UC challenges companies are experiencing due to the COVOID-19 crisis.

Join webinar