% of issues first response met but on a timeline by hour

[eddy]

Hi
I have the following SLA for First Response :
P1 incident - goal 1hr
P2 incident - goal 2hrs
P3 incident - goal 4hrs

i would like to present this as :
percentage of issues were first responded in less than 1hr, 1.5, 2, 2.5hr etc
i want the timeline to be in hours and not days, month etc.

any idea how i can present the timeline in hours?
i tried the difference in hours between issue created and time to first response…
DateDiffHours(
[Measures].[Issue created date],
[Measures].[Issue Time to first response Due date]
)

thanks

[daina.tupule]

I would suggest considering defining and importing additional Time to first response interval dimension using calculated JavaScript custom fields.

Here is an example definition for the field:

[jira.customfield_elapsedt]
name = "Time to first response interval"
data_type = "integer"
dimension = true
javascript_code = '''
totalElapsed = null;
if(issue.fields.customfield_NNNNN && issue.fields.customfield_NNNNN.completeCycles ){
    issue.fields.customfield_NNNNN.completeCycles.forEach(function(completedcycle){
    totalElapsed += completedcycle.elapsedTime / 1000;
});
issue.fields.customfield_elapsedt = totalElapsed;
}
'''
time_unit = "seconds"
time_interval = "duration"
intervals = "1,2,4,8"
interval_unit = "hours"

Please use Time to first response custom field ID instead of NNNNN in all places in the formula.

I used the hours as an interval unit. You can set the full hours there only, though. If needed, set the interval minutes and set values in minutes to get the 0,5h (30m) and 1,5h (90m).

Add the custom field definition to eazyBI advanced settings or ask Jira administrator or eazyBI administrator to do this for you. eazyBI advanced settings are common for all accounts, and only Jira/eazyBI administrators have access to the settings.

Open import options for edit after changes in advanced settings and select the custom field for import as dimension and run an import.

Then you will be able to use this dimension in the report. You might want to check how to set the needed intervals.

Add the dimension to Rows and expand to member level. Add measure Time to first response issues to the report. Click on the header of the measure in the table chart and use Add calculated > Total or Rows to get the % for each interval. Then select the measure Time to first response & for the report only and switch to Bar chart. I would suggest using a filter by Time to first response state - Completed as well. The interval dimension will work for completed cycles only.

Here I made a similar report using another SLA Time to resolution with a similar dimension Time to resolution interval:

Daina / support@eazybi.com

[eddy]

@daina.tupule

.

Hi Daina

It worked as expected.
Thank you very much.

[AntonBDR]

Very interesting report!
Please excuse this basic question, but how do I find the name of my “Time to first response custom field ID” in order to replace the NNNNN in your formula?

Thanks!

[eddy]

Hi Anton
By editing the custom field you can see the ID in the URL.
Admin - Issues - Custom field, search for your custom field and click configure.
you see the url like this :
www.yoursite.com/secure/admin/ConfigureCustomField!default.jspa?customFieldId=10829
10829 is the ID

[daina.tupule]

You can also open the import options in eazyBI and mouse over a particular custom field, in this case, your SLA. eazyBI should show you the custom field ID in a small pop-up.

Daina / support@eazybi.com