Can we report on time of day ticket creation

lee_802cws

Hello, we are trying to construct a report that shows how many ticket were created out of hours vs in hours. Something like 

Hour / Day:      day x | day y | day z

00:00-08:00        4    |    5     |   2

08:00-16:00        4    |    6     |   2

16:00-24:00        6    |    5     |   11

Or even just 

 

Hour / Day:      day x | day y | day z

9-5                    4    |    5     |   2

5-9                    4    |    6     |   2

I found another answer however the link was expired. Thanks

Liam Green

Hi @lee 

The following should be what you need:

00:00 - 08:00

project = "Project Name" and created > startOfDay("-24h") and created < startOfDay("-16h")

 

08:00 - 16:00

project = "Project Name" and created > startOfDay("-16h") and created < startOfDay("-8h")

 

16:00 - 24:00

project = "Project Name" and created > startOfDay("-8h") and created < startOfDay("0")

 

They will show you tickets from yesterday - the hours will need to be adjusted for the day before, etc.

Whilst you couldn't get this into a report, you could put it into a dashboard showing a 'rolling' 7 days, meaning you would need to capture it every couple of days to avoid having to rerun the filter.  Alternatively, you could have the filter set to email to yourself, but this may not be appropriate depending on how many tickets you get.