Question

2
Replies
71
Views
Close popover
Vudumula Chiranjeevi (VudumulaC)
Cognizant Technology Solutions

Cognizant Technology Solutions
IN
VudumulaC Member since 2016 11 posts
Cognizant Technology Solutions
Posted: September 10, 2020
Last activity: September 10, 2020
Solved

How to get top 5 records based on count column in Report Definition: Pega 8.4

Hi ,

We have an application say ABC which has 300 users who will create cases regularly. I want to fetch top 5 users who created the highest number of cases, and display the result in bar chart. The chart X-axis shows User ID and Y-axis shows Count of Cases created by them.

Currently i am just displaying the chart with all User ids and count of cases created by each user. But i want to get only top 5 users who created highest cases using Report Definition. Can anyone suggest how to achieve it.

We are using Pega 8.4. Thanks!

Pega Platform 8.4 Reporting Financial Services Pega Academy