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!

[Deepa Srivastav]

Thanks for your feedback Nichanal. can you clarify what kind of sorting you need in second case i.e list table ? max number of incident category should come first ..? and in excel also it should show up like that?

[mint]

Yes, Max number of incident category should come first and Excel should show up like that.

Thank you Deepa.

[Deepa Srivastav]

I don't think Nichanal this can be done with what is available OOB ,though I m not very sure...

Hit Like or Helpful if you find my response worthy.

[Michael190]

Hello Nichanal,

This is an old post but I had the same request and came across this post.   You should be able to accomplish this by adding a choice to the choice list.   The table is 'sys_report' the element is 'other_threshold'

[kvillalobos]

Thanks Michael. Just what i needed!