Show data only if aggregrate count is greater than x?

[Nisar2]

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]

Hi,

Wait a minute. This count is for the same table on which this report is? Or this is dependent on some other tbale.

Can you tell what report you are looking for so we can help you.

Thanks,
Ashutosh

[Nisar2]

Yes, same table (incident)

Use case is such that for all incidents created this month, I would want to know how many incidents are under each Customer ID (incident is parent table, u_customer is child to incident)

And I only want to grab data is the count of incident is greater than "x", say 10.

[Ashutosh Munot1 · Accepted solution]

Hi,

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

Thanks,
Ashutosh

[ram prasad]

Is this Solved? I have same requirement. I want to pull count of case ticket which state was in "Hold" for more than 3 times.