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!
Accepted Solution
Updated: 10 Sep 2020 11:19 EDT
Cognizant Technology Solutions
IN
Hi Devadharshini,
Thanks for the response. My query was different from what was asked in above article. Anyways i found the solution by applying sort on aggregate(count) column. Thanks.
Pegasystems Inc.
IN
Accepted Solution
Updated: 10 Sep 2020 11:19 EDT
Cognizant Technology Solutions
IN
Hi Devadharshini,
Thanks for the response. My query was different from what was asked in above article. Anyways i found the solution by applying sort on aggregate(count) column. Thanks.