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

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

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/atul_grover_lng [ Connect for 1-1 Session]

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

Community Alums
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...

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

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/atul_grover_lng [ Connect for 1-1 Session]

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