eazyBI currently does not offer an out of box Time to SLA integration however we provide a custom tailored solution in our app to let you harvest rich SLA information right trough eazyBI.  

You need eazyBI Reports and Charts for Jira which is a third party Jira app. Find more details here.

Configuration


After you installed and setup eazyBI, you need to do some configuration for eazyBI reach your Time to SLA fields.

1. First define a eazyBI Integration Field custom field in your Jira instance.

2. Then switch to eazyBI and Settings option in configuration menu.


3. Introduce your eazyBI integration field to eazyBI by adding following line under Advanced Settings section. You should change 11_500 with the ID of the custom field you have defined in step 1.

[jira.customfield_11500]
data_type = "string"
dimension = true
name = "EazyBI Integration Cf"

                                     

4.  Go to Source Data page and click Edit button next to your Jira app. 

Then go Custom fields section under Jira import options. Check "Import as dimension"  checkbox of Time to SLA eazyBI custom field and then click to import button.

5.  After importing is done, you can start to create your eazyBI fields for different attributes of your SLA data. For this you need to write your custom field code in Advance Settings under the eazyBI settings.
Below, we define a two new eazyBI custom fields as an example.  The first one gets SLA status by issue and the second one gets SLAs start date field.

[jira.customfield_ttsSlaStatusCf]
data_type = "string"
name = "TTS eazyBI SLA status custom field"
javascript_code = '''
if(issue.fields.customfield_11500){
var jsonObject = JSON.parse(issue.fields.customfield_11500);
var slaStatusArray = [];
jsonObject.forEach(function(value) {
if(value.slaStatus !== null){
   slaStatusArray.push(value.slaName +":"+ value.slaStatus);
}
});
 issue.fields.customfield_ttsSlaStatusCf = slaStatusArray;
}
'''

             

[jira.customfield_ttsSlaStartDateCf]
data_type = "string"
dimension = true
name = "TTS eazyBI SLA start date custom field"
javascript_code = '''
if(issue.fields.customfield_11500){
var jsonObject = JSON.parse(issue.fields.customfield_11500);
var startDateArray = [];
jsonObject.forEach(function(value) {
if(value.startDate !== null){
   startDateArray.push(value.slaName +":"+ value.startDate);
}
});
 issue.fields.customfield_ttsSlaStartDateCf = startDateArray;
}
'''

Final configuration looks like this with given settings:   

If you change something on your custom field configurations on this page after your first import, you need to truncate "jira_issues" table in eazyBI database and then import data source again otherwise imported data might not reflect your changes.

You can use following properties in your eazyBI reports:

DescriptionKeyType
SLA IDslaIdLong
SLA  NameslaNameString
SLA Calendar NameworkingCalendarNameString
SLA StatusslaStatusEnum
SLA DurationslaValueAsDurationStringString
SLA DurationslaValueInteger (Seconds)
SLA Start DatestartDateDate
SLA End DateendDateDate
SLA Target DatetargetDateDate
SLA Elapsed DurationworkingDurationInteger (Seconds)
SLA Remaining DurationremainingDurationInteger (Seconds)
SLA Overdue DurationoverdueDurationInteger (Seconds)
SLA Paused DurationpausedDurationInteger (Seconds)
SLA Elapsed PercentageelapsedPercentageInteger
SLA in Critical Zone?inCriticalZoneBoolean
SLA PausedpausedBoolean
SLA Started?startedBoolean
SLA Finished?finishedBoolean


Working duration, remaining duration, overdue duration, paused duration and SLA value is in seconds. You can format them however you want.

Get Report


1. Go to the Analyze page under the eazyBI. And then choose which custom fields you want to see. 

2. Now you can get a report with SLA information you have defined.

For more information, you can visit eazyBI custom fields, JavaScript calculated custom fields and advanced settings for custom fields page.