How to show tickets closed for the past 10 days by a department (not including the current day)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-16-2022 03:36 AM - edited ‎12-16-2022 04:54 AM
Hello,
I am trying to build a report which shows the requested items and incidents closed by a specific department in each of the past 10 days. I am using the "Trend" report type, grouping by "Closed" and Trend by "Closed". Please see the attached image of additional filters.
The issue I am having is that the report is calculating tickets relative to when I run the report (If I run the report at 3pm, it will go back to yesterday's 3pm and take those 24 hours as one day). The report is then dividing up each day's data into 2 segments which I don't want.
I want the report to take the previous 10 day's tickets (10 days ago from 12am on the day I run the report). I have attached an image of the report to help further understand my issue.
NOTE: As highlighted in the screenshot, the relative date is picked up.
Can someone please suggest a solution to this?
Thank you!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-16-2022 04:37 AM
Here is a sample.
My script include returns the top 5 records' sys_id ,and the report filter set the script include's result as a flter condition.
As the same mind, you just need to modify the script and let it return the target records' sys_id list.
In the scripts include ,you can freely set the search condition .
Have a try~
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-16-2022 04:53 AM
Hi @RashiKul,
You can get the list of closed records in last 10 days from yesterday, by using below condition in conditions builder. You need to use relative operator and that should do that trick. You can club this condition along with your department condition. Do let me know if you need any further help.
Please mark this as correct and helpful if it solved the query.
Mohit Kaushik
ServiceNow MVP (2023-2025)