| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
This page is about Time to SLA integration of Private EazyBI eazyBI for Jira On-Prem. If you are running the EazyBi eazyBI app for jiraJira, please see the following page Integrate Time to SLA with eazyBI. |
Private 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 eazyBIthis app.
Prerequisites
You need
...
Private eazyBI, which is a stand-alone application. 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.
| Note |
|---|
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.tomlfile, please add the custom field that was created in step Step 2 with its idID. On In the following example, the id ID of the eazybi 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”"string"dimension = truename =“TTSEazybiCF”"TTSEazybiCF"On the Private Eazybi UI, under source data → custom fields → please eazyBI UI, navigate to Source Data, and click Custom Fields.
| Note |
|---|
You must ensure that the |
...
After the changes, please perform an import for Jira source data.
After importing is done, you will need to create a new eazyBI calculated field by clicking “Add Add a new calculated field” field under source data → > custom fields for different attributes of your SLA data.
After the creation of the new field. Incase if the auto import is not performed, please perform an import to import the newly created field in case the auto import is not performed.
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.