eazyBI

This page is about Time to SLA for Jira Data Center.

Time to SLA offers two ways to integrate with eazyBI:

A native integration via the Add-ons tab in eazyBI import options
A manual setup using a dedicated integration field and JavaScript code

Depending on your environment and version of eazyBI, you can choose the method that works for you.

On this page: 1 Prerequisites 2 Option 1: Native integration 3 Option 2: Manual setup 4 Get report

On this page: 1 Prerequisites 2 Option 1: Native integration 3 Option 2: Manual setup 4 Get report

Prerequisites

You must have Time to SLA and eazyBI Reports and Charts for Jira, a third-party Jira app, installed and properly configured in your data center. For more details, see here.

Option 1: Native integration

Go to eazyBI > Source Data and click Edit next to your Jira source.
Switch to the Add-ons tab in the import options.
Locate Time to SLA fields and enable the ones you want.
Complete the import.

Option 2: Manual setup

If your version of eazyBI or Jira doesn’t yet show Time to SLA fields under Add-ons, use the instructions below to configure the integration manually.

Install and set up eazyBI.
Define an eazyBI Integration Field custom field in your Jira instance in the Jira Administrators menu > Issues > Custom Fields > TTS-eazyBI Integration.

Before moving on to the third step, you need to get the ID of the custom field you just created. To see it, you can click Edit, and check the URL – the ID will be at the end of the URL.

Switch to eazyBI and select the Settings option in the configuration menu.
Introduce your eazyBI integration field to eazyBI by adding the following line under the Advanced Settings section. You should change 11500 with the ID of the custom field you have defined in step 2.

Import Time to SLA eazyBI Custom Field

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

Go to the Source Data page and click the Edit button next to your Jira app.
Go to the Custom fields section under Jira import options. Tick the Import as dimension checkbox of the Time to SLA eazyBI custom field and then click the import button.

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 two new eazyBI custom fields as an example. The first one gets SLA status by issue and the second one gets SLA start date fields.

Create eazyBI custom fields

[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;
}
'''

The final configuration looks like the below image with the given settings.

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

You can use the following properties in your eazyBI reports:

Description	Key	Type

Description	Key	Type
SLA ID	slaId	Long
SLA Name	slaName	String
SLA Calendar Name	workingCalendarName	String
SLA Status	slaStatus	Enum
SLA Duration	slaValueAsDurationString	String
SLA Duration	slaValue	Integer (Seconds)
SLA Start Date	startDate	Date
SLA End Date	endDate	Date
SLA Target Date	targetDate	Date
SLA Elapsed Duration	workingDuration	Integer (Seconds)
SLA Remaining Duration	remainingDuration	Integer (Seconds)
SLA Overdue Duration	overdueDuration	Integer (Seconds)
SLA Paused Duration	pausedDuration	Integer (Seconds)
SLA Elapsed Percentage	elapsedPercentage	Integer
SLA in Critical Zone?	inCriticalZone	Boolean
SLA Paused	paused	Boolean
SLA Started?	started	Boolean
SLA Finished?	finished	Boolean
Calendar Business Day Hours	businessDayHours	BigDecimal (Hours)

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

Get report

Go to the Analyze page within eazyBI and choose which custom fields you want to see.
Now you can get a report with the SLA information that you have defined.

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