Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

How do I limit report results to a minimum count?

Jeff M-
Giga Contributor

Vancouver release.
How do I limit report results to say minimum count of X number of incidents?  See the screen shot - way too much info coming back from my query. I though I was on the right track with the related list conditions (Greater than or equal to 30) but didn't see how to continue from there.

4 REPLIES 4

Dr Atul G- LNG
Tera Patron

Hi @Jeff M- 

 

https://docs.servicenow.com/bundle/utah-now-intelligence/page/use/reporting/concept/c_CreateBarChart...

 

https://www.servicenow.com/community/platform-analytics-forum/setting-a-scale-on-bar-charts/m-p/1220...

 

Seems possible by Set Formatting Value

*************************************************************************************************************
Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/dratulgrover [ Connect for 1-1 Session]

****************************************************************************************************************

Not applicable

Jeff M-
Giga Contributor

@Community Alums  - is there a way to limit the results to a minimum count without using JavaScript?  I am not an expert and would prefer to stay in the GUI and make a query if possible.

@Dr Atul G- LNG - When I click on 'Set Value Formatting' I get this message:  

Value Formatting

No formatting options are available for the selected field types.

Hi @Jeff M- 

 

Try these links

 

https://docs.servicenow.com/bundle/vancouver-now-intelligence/page/use/reporting/reference/value-for...

 

 

https://docs.servicenow.com/bundle/vancouver-now-intelligence/page/use/reporting/concept/c_CreateCol...

 

*************************************************************************************************************
Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/dratulgrover [ Connect for 1-1 Session]

****************************************************************************************************************