Guys, I’m having a hard time here to put together a heat map, where I must measure:
Day + week in line
Time (from 00:00 to 23:00) in columns I will attach an example here, I already managed to arrive in DAYS + WEEKS in lines but I cannot measure the number of tickets per hour within the day!
You can create a new dimension to indicate in which hour issue was created, and a code example is posted in another community post that you can reuse:
Keep in mind that this dimension only indicates the hour when an issue was created.
If you need hour from some other date time picker customfield, then you can adjust this code to this (change NNNNN to your customfield ID):
name = "Hour of Day Incident Start"
data_type = "integer"
dimension = true
var hours = new Date(Date.parse(issue.fields.customfield_NNNNN)).getHours();
issue.fields.customfield_hour_of_day_incident_start = hours;
Also, you can create a measure to indicate which weekday it is: [Time].CurrentHierarchyMember.Get('Week day name')
Use cell formatting to set up limits for your heat map (check “eazyBI for Confluence” demo report to see how it can be done).
Or wait a bit for the next eazyBI version where improved cell formatting for heat maps are going to be added)!
The above code (in the previous answer) will create a new dimension based on your Jira customfield date-time. In data import you need to select both fields (as in my example “Incident start date” and “Hour of Day Incident Start”).