How many tickets created out of hours?

[israel siboni]

Hi,

Is there a way to generate a report\filter for a certain time range the that will show the amount of created tickets outside the working hours?  

[Bill Sheboy · Accepted solution]

Hi @israel siboni -- Welcome to the Atlassian Community!

How often do you need to do this, and what effort/cost are you willing to invest?

• One time need, with some effort with no cost:
  • Export your issues of note to a spreadsheet, use a formula to get the create time, and use a pivot table to analyze
• Not one-time and not frequent, with some effort with no cost:
  • Same as above, but build your report using the Google Sheets or Excel Addins from Atlassian to make this repeatable
• Frequent need, and little effort with higher cost:
  • Acquire a tool from the marketplace for reporting or extending JQL for calculated fields
• Frequent need, and more effort with lower cost:
  • Build an automation for Jira rule to create a histogram of created by hours, using lookup issues, text, and list functions

Kind regards,
Bill

[Mikael Sandberg]

Hi @israel siboni,

Welcome to Atlassian Community!

You can use a filter like the one below to get all issues that were created outside of working hours. There is no option to use businessHours as part of your JQL, so if you would like to see the numbers for the full week you would have to expand the JQL to include each day.

This example JQL will give you all tickets created after 5pm Friday (10/23) and before 8am Monday (10/25)

(created >= "2021-10-23 17:00" AND created <= "2021-10-25 08:00")

[israel siboni]

Thanks for the replay, but I am looking for a monthly/yearly report that will show the number of logged issue out off hours.

[Mikael Sandberg]

You are then looking for a reporting app since Jira doesn't provide something like that out-of-the-box. I bet you can do that in eazyBI.

[Daina Tupule eazyBI]

@Mikael Sandberg thanks for mentioning eazyBI app. 

eazyBI has a lot of default measures. While we do not have default measure tickets created out of hours, there are a couple of ways on how to get this. Here is eazyBI community post with a detailed description for a similar topic. 

Daina /support@eazybi.com