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.
There are several option to do this
Best egards, Vasiliy
Thanks Vasiliy
I went with alternativ number 1 and it solved my problem. At least for now.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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:
Here is the plan.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.