Report for Tasks and Incidents within certain hours

[Ivan Williams1]

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 · Accepted solution]

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

[Ivan Williams1]

Thanks for the response, and direct approach. 

I will follow your steps later, and confirm the outcome... 

[Uncle Rob]

No problem.  If you haven't got it working by Friday I'd be happy to jump on a webex with you.

[Ivan Williams1]

Your tips helped! Thanks for all your assistance...

[sayhai2sandeep]

Hi Team 

I am looking for Incident count between 6am to 9am for specific dates

 but i could see tickets created after 9am as well 
can you please check and advice 

 Please suggest