Report for Tasks and Incidents within certain hours

Ivan Williams1 · ‎06-20-2019

I would like to create two reports; one for Incidents and one for Tasks. But, in particular, I would like to see on my report all Incidents and Tasks closed between 17:00 - 19:00, daily.

But, my report does not seem to pull JUST that time frame, i.e. 17:00 - 19:00 daily. Any ideas...(see attached image)?

Thanks

Uncle Rob · ‎06-24-2019

Because your trend conditions are wrong (sorry to be blunt).

Should read:
Closed ON OR AFTER 5pm AND
Closed ON OR BEFORE 7pm

The OR is messing you up (as well as the after/before without hte "on"). In this scenario 10 am would still succeed because it satisfies the before 7pm condition. Paradoxically 7pm would fail because 7 is not before 7.

You could also do...

Closed Trend IS 5 pm OR
Closed Trend IS 6 pm OR
Closed Trend IS 7pm

View solution in original post

Uncle Rob · ‎10-22-2023

It would be WAY better for you to start a new thread rather than resurrect a 4 year old one.
If people answer you correctly they won't even get a correct answer credit.

Anyway... since these numbers are VERY close to the threshold, I'd look to see if local time zone had anything to do with it.

sayhai2sandeep · ‎10-22-2023

Thanks Robert ,can you please advice how to resolve this .Manually when i pull up date wise total count is 12 tickets

but when i used

i get 20 tickets (8 tickets after 9am)
03/10/2023 09:54:02
04/10/2023 09:48:43
04/10/2023 09:16:46
04/10/2023 09:18:52
04/10/2023 09:29:16
04/10/2023 09:40:31
03/10/2023 09:01:14
04/10/2023 09:53:10

sayhai2sandeep · ‎10-22-2023

trend is used with above query but i still see 20 tickets,is there something iam missing
Marked this as New question now