How do we create a filter to show the time (of day) a ticket was raised?

Question

I have seen this question asked without a suitable answer.

I want to look back at a range of dates (month, year, all issues) and see the times the tickets are raised. I would then create a dashboard for this information.

Reason: it will help with scheduling team member's workload.

John Funk · Answer

Thanks for the clarification. You will not be able to get that out of the box with Jira. Maybe a workaround like creating a custom field (single picker drop down type) with different values for each timeframe. Then an automation rule that would populate the value of the field based on an Issue Created trigger and the appropriate IF/Then conditions to determine which value to put in the field.

Then you could create a dashboard with an Issue Statistics gadget to group by the custom field value. Or you could use a Two Dimensional gadget and do two groups like by Issue Type and the custom field.

Sayed Bares [ServiceRocket] · Answer

@Mike Dear I am afraid to say that is not possible in the cloud at this time (please consider upvoting JRACLOUD-41506 ).

Here are some workarounds which you may give them a try:

* Create a custom field with date time picket type. Then create an automation rule which will run when Issue is Created, then edit your custom field and set it to the creation date or {{now}} 
* Use third-party apps like Time in Status Reports or JXL for Jira or perhaps there are more which can search in the Atlassian marketplace

Mike Dear · Answer

The specific word in this question is time.

The time (within the 24 hours we have in a day) that tickets are raised across specified dates.

Example:

Oh look, we have had 50 tickets between 7:00 - 09:00, but only 10 between 12:00 - 14:00 between X date and Y date.