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

General
, , ,
1

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!

2

Hi,

Below article might help you

3

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.