Configure report to show only Top 5

[mint]

Hi all, I am trying to create a report as bar chart to show the top 5 categories with the highest number of incidents occurring in the past 30 days.

However, it only allows you to select the minimum of top 10 (via "No. of group" field). Does anyone know how to set this?

Or if I want to configure it as a "List" (table list), is there anyway I can add a calculated field to count the number of incidents occurred per each category? So then I can sort the list by the number of incidents occurred per category, and it can also be exported out as Excel file which I can further work on it.

Thank you!

[rajmasurkar]

Hi,

Are you looking for something like this?

Raj

[mint]

Yes, but to show only 5 items. It is supposed to be set at the "No. of groups" field (from the graph you showed), but the drop down choices provided only have "10" to be selected as the minimum (i.e. to show only 10 items).

Thank you.

[Deepa Srivastav]

If you want to use list you can put "group by"- category,it will show number of incidents in each cat.

And in bar if you want to show only 5 categories and hard code the extra group name in the 'Filter Condition'.

Check the screens shot .

[mint]

Thanks Deepa.

To clarify on the questions, the point is I am customizing a report for customers so they can see the top 5 categories where incidents occurred the most for the current time period.

So there are two options,

1st option: Using Bar chart

        Because there are many incident categories defined by customer, they want to view only the top 5 categories with highest number of incidents occurred for the current time period. I'm not sure if I understand you correctly, but because these 5 categories may change every time period, we cannot fix the category names in filter condition.

2nd option: Using List - and sort by category according to the number of incidents occurred

        The customer mentioned that if the 1st option is not possible, they would like to see the sorted data that can be exported as Excel file so they can further work on it. I understand that using 'Group by' will show the number of incident in each category, but I need to sort the category by number of incidents occurred --> do you know if this is possible?

Thank you very much for your help.

Nichanal