Is it possible to exclude saturday and sunday as business days from the report?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-06-2020 03:13 AM
Hi,
I have created a report with the list of incidents that are not updated for more than 48 hours and it shouldn't include Saturday and Sunday as the business days.
For example, if the incident is updated on Friday, it should show Monday as the second day. Is there any way in the filter section to make changes.
- Labels:
-
Incident Management
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-07-2020 08:51 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-08-2020 06:59 AM
Hi Nitin,
You can do by using three condition in filter,
1.Updated is less than 24 hr before,
2.updated trend after sunday,
3.updated trend before saturday.
Please mark if that help you!!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-02-2020 02:00 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-28-2021 08:19 AM
Hi
I have the same problem, but the above filters don't seem to make the difference I am expecting.
I have a report that should show incidents that have not been updated in the last 5 working days.
My colleague has added the filters
Updated Trend On Monday OR
Updated Trend On Tuesday OR
Updated Trend On Wednesday OR
Updated Trend On Thursday OR
Updated Trend On Friday
When I run the report with or without the above filters, the only difference seems to be incidents where the last update was on a Saturday or a Sunday. The above excludes these incidents, whereas without it, they are included.
I've also tried the variations above with the same results.
When I run either report today 28th April, it shows incidents not updated after 23rd, 5 calendar days ago, ignoring the fact that I don't want to count Saturday or Sunday in the count, and want incidents not updated after 21st (5 working days ago)