Creating a report for incidents count is more than 3 and having same CI

[Gaurav Vaze]

Hello guys,

I have a requirement for the report, which should provide the user with incidents for a given list of CI

but the catch here is the report should only show those incidents, for which the count of incidents related to that CI is greater than 3.

i.e. if there is CI named x and the incidents including this CI are more than 3; and there is Ci named y and incidents including CI y are less than 3 then the report should show the incidents for x

Any help will be appreciated 

Gaurav Vaze
ServiceNow developer

[Dr Atul G- LNG]

Hi @Gaurav Vaze 

This much comparison is not possible in standard reporting.

[Gaurav Vaze]

I thought so
one of option is calling a script include which will do the magic of checking counts right?
I'm quite confused if that script include will run every time the report is run?

[Dr Atul G- LNG]

I am not sure buddy about this. But it will increase a technical debt. 

[Gaurav Vaze]

Yeah agreed
Thank you for your response