Show data only if aggregrate count is greater than x?

Nisar2 · ‎08-06-2020

Hi experts,

I'm using a vertical Bar graph report. In that I'm grouping on a column with aggregation set to "Count". This does the work but I was wondering if I could narrow down the list by having a condition that shows data only if count value is greater than, say, 50.

Right now, when I run the report it also shows data when count is 1 and I would rather not have that displayed.

On a side note, is it possible to show only "Data table" and hide the graph altogether?

Ashutosh Munot1 · ‎08-07-2020

Hi,

This can be used Instead of caller table you use customer table and then greater than 10.

Thanks,
Ashutosh

View solution in original post

Muralidharan BS · ‎08-06-2020

Hi Nisar,

There is no straight forward option to show count greater than 2. You can create a script include and call that in the report to restrict only the specific sysid.

refer this article for - https://community.servicenow.com/community?id=community_article&sys_id=039f65f61b495010a59033f2cd4bc...

Thanks

Nisar2 · ‎08-06-2020

How scalable is this approach? On a PROD instance, using a filter to call a script include seems quite dangerous.

Ashutosh Munot1 · ‎08-06-2020

Hi,

You can use related list conditions and using a script in filter is not always an issue. Depends on how write it and how much data is there

Thakns,
Ashutosh

Nisar2 · ‎08-07-2020

In related list conditions, how will I be able to grab hold of the count?