Recurring Incidents Report

[Kim Andre Espe1]

Hello. 

I want to create a report that should show me all incidents that have been created the last 31 days. 
Conditions should be, group by CI(Customer ID), and it should only show groups with 5 or more Incidents in them. 

Anyone have any tips for me? 

Br 
Kim Andre Espeseth

[Alberto Consonn · Accepted solution]

Hi,

create the report with the following condition

For showing only groups with at least 5 incidents, please try the solution provided by Michael in the below thread, it should work fine!

https://community.servicenow.com/community?id=community_question&sys_id=ef700be1db98dbc01dcaf3231f96...

Hope this will be useful for your need!

Enjoy:-)

If I have answered your question, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.

Thank you

Cheers
Alberto

[Kim Andre Espe1]

"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'" 

You know where this is? 

[Kim Andre Espe1]

Never mind i found it 🙂