This page is about Time to SLA integration of Private EazyBI for Jira On-Prem. If you are running the EazyBi, please see the following page Integrate Time to SLA with eazyBI
eazyBI currently does not offer an out-of-the-box Time to SLA integration. However, we provide a custom-tailored solution in our app to let you harvest SLA information right through eazyBI.
Prerequisites
You need eazyBI Reports and Charts for Jira, which is a third-party Jira app. Find more details here.
Configuration
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 within eazybi.toml file, please add the custom field that was created in step 2 with its id. On the following example the id of the eazybi custom field is 11400.
[source_application.jira.site_99]
url = “http://localhost:8080/jira”
[source_application.jira.site_99.customfield_11400]
data_type = “string”
dimension = true
name = “TTSEazybiCF”On the Private Eazybi UI, under source data → custom fields → please ensure that the TTSEazybiCF field is set as dimension.
After the changes, please perform an import for Jira source data
After importing is done, you will need to create an an eazyBI field by clicking “Add a new calculated field” under source data → custom fields for different attributes of your SLA data.
After creation of the new field. Incase if the auto import is not performed, please perform an import to import the newly created field.
You can use the following properties in your eazyBI reports:
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 are 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.