Time to SLA & Private eazyBI

Owned by Derya Özdemir
Last updated: May 06, 2024
3 min read

This page is about Time to SLA integration of Private eazyBI for Jira On-Prem. If you are running the eazyBI app for Jira, please see the following page https://appfire.atlassian.net/wiki/spaces/TTS/pages/54362239.

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 this app.

Prerequisites

  • You need Private eazyBI, which is a stand-alone application. Find more details here.

Configuration

  1. Install and set up eazyBI.

  2. 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.

  1. Switch to eazyBI and within eazybi.toml file, add the custom field that was created in Step 2 with its ID. In 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"

  2. On the Private eazyBI UI, navigate to Source Data, and click Custom Fields.

    image-20240506-090543.png

You must ensure that the TTSEazybiCF field is set as dimension.

After the changes, perform an import for Jira source data.

  1. After importing is done, create a new eazyBI calculated field by clicking Add a new calculated field under source data > custom fields for different attributes of your SLA data. 

    image-20240506-091108.png

  2. After the creation of the new field, 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

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)

Get Report

  1. Go to the Analyze page within eazyBI and choose which custom fields you want to see. 

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