| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
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.
...
| 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. |
...
1
2
3
4
...
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
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 =
...
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.
...
“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 can start will need to create your eazyBI an an eazyBI field by clicking “Add a new calculated field” under source data → custom 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
...
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
...
...
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
...
[jira.customfield_ttsSlaStartDateCf]data_type = "string"dimension = truename = "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.
...
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) |
...
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.
| Info |
|---|
For more information, you can visit eazyBI custom fields, JavaScript calculated custom fields, and advanced settings for custom fields page. |