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

[Mike Dear]

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.

[Sayed Bares [ServiceRocket]]

@Mike Dear if you want to filter issues based on range of dates then you can do a JQL search like this:

created > 2023-01-01 and created < 2023-07-25

This will return all issues which were created from  2023-01-01 until 2023-07-25.

However, if you want to show the creation date of an issue then make sure that created is added to your columns:

Then you can save your filter and by using Filter Results Gadget and adding Created column you should be able to show your data in your dashboard.

[Mike Dear]

Thanks, but the specific word in this question is time - not date.

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

[Sayed Bares [ServiceRocket]]

@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:

1. 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}} 
2. 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

[John Funk]

Hi Michael, 

Can you be more specific? What exactly is one thing that you want to see? 

[Mike Dear]

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.

[John Funk]

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.