I'm looking for a way to generate a report showing the number of tickets that were created at each hour throughout the day and display it on a chart.
EazyBI doesn't seem to drill down to the hour and I can't see any gadgets that would do this.
Any suggestions appreciated.
I managed to do this by exporting all Jira issues from 2017 to a CSV, then creating 2 columns:
Ticket: Custom column with 1 as the value in each cell.
Hour: The hour in HH format split from the date/time columns, sorted by descending numbers.
Hour | Ticket
13 | 1
14 | 1
14 | 1
15 | 1
15 | 1
This was plotted this on a line graph with hour along the x-axis and number of tickets on the y-axis, giving us a chart showing the total number of tickets logged at each hour of the day over a 1 year period.
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
@Rachel Wright (Jira Genie), @Billy Poggi (AUG NOVA, DC), and @Dana Jansen (Confluence Queen) are just some of the folks that lead one of the world's most active Atlassian User Group (AUG)....
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs