Exclude weekends from report condition

Jaehee Kim
Kilo Contributor

How can I exclude weekends from the condition?

find_real_file.pngI would like to see only the tasks created 4 days ago based on working day.

 

Thanks in advance,

1 ACCEPTED SOLUTION

mr18
Tera Guru
Tera Guru

Hi Jaehee,

Try below filter condition

find_real_file.png

View solution in original post

5 REPLIES 5

Ankur Bawiskar
Tera Patron
Tera Patron

@Jaehee Kim 

refer below links for help

Excluding Weekends From Reports When You're Reporting On 'Dates'

Reports Tickets created on last week days (should count from Saturday to friday not sunday to Saturd...

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

mr18
Tera Guru
Tera Guru

Hi Jaehee,

Try below filter condition

find_real_file.png

ram prasad
Tera Contributor

Hi ,

 

I want to see the graph with tickets which are not updated more than 4 days ago(working days).  If Saturday, sunday falls into this 4 days then it has to exclude them adjust that between Monday-Friday. How do i get that??

 

 

Ragha Vihar1
Tera Contributor

Hi @ram prasad -  Have you got the solution to the above requirement? If yes, please let me know how it is achieved. Thanks.