A report of top 5 Incidents

[Amit158]

I have create a monthly Incident report which is grouped by Reference 1 field, and the report shows the count of "category data" in Reference 1 field. For each month I only want to show top 5 count. Is it possible without using scripts?

[Tushar Hirpurk1]

Hi Amit,

            "Max number of groups" option is not available for when you are selecting type as time series,

i would suggest you can use the Bar, horizontal bar or pareto type so that you can get the result, you can do additional group by if you want to group the report with 2 entities.

by default in Max number of groups their are only 6 options available like system default, show all, 10,12,15,20

but if you want to add you own as 5 then you can do it as

Goto the choice table and create a choice with below values.

Table - sys_report

element - other_threshold

value - 5

Label - 5

You will see the option 5 in your report

Please mark reply as Correct/Helpful, if applicable. Thanks!

Regards,

Tushar

[Tushar Hirpurk1]

I just wanted to check-in on this and see how things were going for you.

If my reply above helped answer or guide you correctly, please mark it as Helpful & Correct.

Thanks!

[Amit158]

Thanks Tushar for your reply. But I don't have access to choice tables.

What I am trying to do is control the number of items within a group. I don't want to control the number of groups. I think this can't be achieved by an end user until they have access to run scripts.