Report on tickets opened by time

[Ann Marie Guinan]

Hi all, 

I am trying to report on tickets opened by time of the day but I can only open it by date. 

Can you help please?

[Ann Marie Guinan · Accepted solution]

Tickets opened by the time of the day:
For this requirement, may I kindly request you to refer to the following post wherein JQL is used to obtain Jira issues that are created within a time range using startofday() JQL function: How can I create a JQL filter with a time-range between two dates

The above suggestions are based on JQL functionality available natively in Jira. If you would like additional reporting functionality, then I would kindly request you to review our marketplace for third-party addons that may help: Atlassian marketplace. Some add-ons that I could find are:

• EazyBI Reports and Charts for Jira
• Reports and timesheets for Jira

However, please note that these addons are supported by third-party vendors and for a specific addon functionality or support, we would suggest reaching out to the vendor support team.

[Juan José Marchal Gómez]

Hello @Ann Marie Guinan

if you set the mouse over the "Created" you can see the time.

Also, if you export the report the created datetime appears.

Best regards.

[Ann Marie Guinan]

Hi Juan,

These were the steps we had to take:

Tickets opened by the time of the day:
For this requirement, may I kindly request you to refer to the following post wherein JQL is used to obtain Jira issues that are created within a time range using startofday() JQL function: How can I create a JQL filter with a time-range between two dates

The above suggestions are based on JQL functionality available natively in Jira. If you would like additional reporting functionality, then I would kindly request you to review our marketplace for third-party addons that may help: Atlassian marketplace. Some add-ons that I could find are:

• EazyBI Reports and Charts for Jira
• Reports and timesheets for Jira

However, please note that these addons are supported by third-party vendors and for a specific addon functionality or support, we would suggest reaching out to the vendor support team.

[Juan José Marchal Gómez]

I didn't work with "Reports and timesheets for Jira", I can not help you about this plugin.

But...I'm working with EazyBI and it's amazing. You can do all your want with this application.

If you can buy it...will be the best solution.

Also, their support is "5 stars always". 

@[deleted] could you help this user to answer if her request can be solved with your pluggin :)

Best regards!

[Ilze Leite-Apine - eazyBI]

Hi @Juan José Marchal Gómez 

Thank you for good words :)

By default, eazyBI groups data by days as the most granular level in the Time dimension. However, using the JavaScript calculated custom field option, you can precalculate and import a new "Hour of day Created" dimension and see this information split by hours.

There is an eazyBI community thread that describes this solution: Generate count of issues created per day and per hour. Feel free to contact us via email at support@eazybi.com for assistance!

Best, 

Ilze / eazyBI support