Report Filtering Question
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-19-2024 10:22 AM
Hello,
Forgive me if this is answered somewhere else. I'm still learning the software and wasn't finding the answers I was looking for in my searches.
I have a report I need to create that returns a table with all the tickets with the following filters. I can not figure out how to write an expression (first condition below) as a filter for a report in ServiceNow. Any assistance would be appreciated. Our end goal is to identify the requests / issues reported most often by our new hires with in their first week.
Report Filters:
Task.Created - Requested for.Start date <= 7 Days
Task.Created >= YTD
Requested for.Support Region = "North America"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-19-2024 10:48 PM
Hi @AMercier ,
Your expression / condition should be chosen in the condition builder. You can dot-walk from task/incident/request to the user table, but where do you have the callers start date located? which table? and where do you have support region stated? which table?
If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
best regards
Anders
If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.
Best regards
Anders
Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-20-2024 01:42 AM
Hi @AMercier
I think, the basic information is missing here, if you provide table name and how and from where you are fetching support region, we can help you further.
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]
****************************************************************************************************************