Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Report showing incidents between 8pm fri and 8am mon - how???

Christine Ayre
Kilo Contributor

Hi,

I think I may be asking too much, but I ideally need 1 report showing the trend of tickets raised on a weekly basis between 8pm on a friday though to 8am on a monday, by priority. 

I have figured out trend but you can't chose hour and day together.

Any easy suggestions without going into the scripting or similar?

Thanks

7 REPLIES 7

Yaraslau
Tera Guru

Give us what you have with pictures please

Christine Ayre
Kilo Contributor

find_real_file.png 

and I only get tickets created over night - I also want those during the day sat & sunday

The problem is that I want all tickets created between 8pm fri and 8am mon.

As I can see you already set Trend By Created

Just try to use Created on or after and  your time

Or I don't got right your point

Christine Ayre
Kilo Contributor

I want all tickets raised after 8pm on a friday until 8 am on  a monday - so:

20:00 - 23:59 friday

00:00 - 23:59 saturday

00:00 - 23:59 sunday

00:00 - 07:59 monday

 

This report gives me the following:

20:00 - 23:59 friday

00:00 - 07:59 saturday

20:00 - 23:59 saturday

00:00 - 07:59 sunday

20:00 - 23:59 sunday

00:00 - 07:59 monday

So I am missing those between 08:00 and 19:59 on both sat & sun.