Is it possible to exclude saturday and sunday as business days from the report?

Nithin22
Kilo Explorer

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. 

5 REPLIES 5

Ishita Shrivast
Kilo Guru

Hi Nithin,

Try giving conditions while creating report on Created field. For reference , see below image.find_real_file.png

Please mark it as helpful and correct, if applicable.

Thanks and Regards,

Ishita Shrivastava.

Priya Shid1
Kilo Guru

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

Krishna73
Tera Expert

Hi Nithin,

 

You just need to put below mentioned 2 lines, your requirement can be achieved.

find_real_file.png

Please mark helpful if this resolves your issue and close this thread.

 

Thanks,

Krishna

Steve181
Kilo Contributor

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)