It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to count the number of issues created per hour

Tonny Vildevall Jan 31, 2017

We need to know when our staff should be on call and therefor need to know at what time the most issues are created. 

I would like to create a report that displays how many issues that has been created per hour during the selected amount of time. 

The result could look something like this.

Hour  : Issues

0 : 0

1: 0

2: 0

....

7: 1

8: 11

9: 15

10: 2

11: 4

and so on. 

1 answer

1 accepted

0 votes
Answer accepted
Vasiliy Zverev Jan 31, 2017

There are several option to do this

  1. Export to excel and so all analitics here
  2. Create custom field to store hour of a day when issue created and then use it for analitics.
  3. Create a lot of filters like: createdDate > startOfDay() AND createdDate < startOfDay(1h) for each hour and analise statistics

Best egards, Vasiliy

Tonny Vildevall Feb 01, 2017

Thanks Vasiliy

I went with alternativ number 1 and it solved my problem. At least for now. 

Artem Setkin Mar 12, 2018

Hi, 

 I am looking for a solution to create a dashboard which will work like some sort of an activity chart and will allow us to see: 


1) what is a number of issues created/updated by all customers per every hour during a week.
2)    what is a number of issues created/updated by only selected customers per every hour during a week.  

The goal is simple: to display when our clients are active the most. (We provide 24/7 tech support using JIRA with ServiceDesk plugin). 

Is it really the best possible solution to export data to excel or have anyone found a better one? Many thanks

Vasiliy Zverev Mar 12, 2018

So, you need to store somewhere a hour of created date.

First of all a new custom field requared. It seem to be a number type and strore there values from 0 to 24 which repsents each hour.

Then it is requared to fill this value. Anyway you need a script to get current hour. Then it could be placed to:

  • postfunction into create transition (if you have 1-2 workflows)
  • event listener for issue create event (if you have a lot of WF where you need to store this value)

Here is the plan.

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published in Next-gen

Introducing subtasks for breaking down work in next-gen projects

Teams break work down in order to help simplify complex tasks. This is often done iteratively, with tasks being broken down into smaller tasks and so on until the work is accurately captured in well-...

11,126 views 54 53
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you