How to get percentage of a value in insights in infinity 25' version

User Experience
1

There is a requirement to get the percentage of an integer field added in insights in Pega infinity 25’ version, I am not able to get the percentage in aggregate function.

Requirement:
We have a column called NPS Score in the Tickets Data Set.
The requirement is to calculate the percentage of Promoters, i.e. the percentage of tickets with an NPS score of more than 9.

How to achieve this in Insights.

2

@NanthithaB17284071 a really good question! It is not as simple as it first appears.

I would use a pie chart with the values displayed, you can even apply custom groups so if “above 9” and “9 and below” are important, you can create that in dimensions.

image
image1794×868 93.1 KB

So its not just a matter of showing the percentage but what about the underlying need? I’m probably going to need to know simple things like:

  1. What about count? (50 over a score of 9 and 2 under)
  2. What about drilling to the records? Perhaps to look at more details about why a good or bad score was achieved.
  3. Adding additional filters or layers: perhaps I want to see by region, provider or other measure. Insights allows you to add more dimensions so we can cascade different data in the Insight.

Hope that helps.

3

@NanthithaB17284071

I’d like to move this to User Experience, to go with the other Constellation posts.

image
image1176×627 33.5 KB

However, you are not a member, if you can join then that will allow me to move this (only members can reply to User Experience posts, so you would no longer be able to reply).

Let me know when you join and i’ll move this.

4

Hi Marc,
Thanks for your reply.
How to use simple value chart to get percentage value for each as shown in the below image.
I was planning to use separate insights for each category, and refer them in dashboard, but I am getting count only not percentage.

Could you help me to achieve this requirement.

image
image1292×276 14.2 KB

Thanks,
Nanthitha

5

I don’t believe you can achieve this UI with Insights.

It does have gauges

image
image1311×767 58 KB

but making a percentage of a simple integer, sourced as a calculation of total results, I can’t find a way with Insights. Perhaps building your own DX component would get the exact UI you are after?