Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Panel
panelIconIdatlassian-info
panelIcon:info:
bgColor#F4F5F7

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

...

this app.

Prerequisites

  • You need Private eazyBI

...

  • , which is a

...

  • stand-alone application. Find more details here.

On this page:

Table of Contents
minLevel1
maxLevel6
outlinefalse
styledefault
typelist
printabletrue

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.

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. Switch to eazyBI and within eazybi.toml file,

...

  1. add the custom field that was created in

...

  1. Step 2 with its

...

  1. ID.

...

  1. In the following example, the

...

  1. ID of the

...

  1. eazyBI custom field is 11400.
    [source_application.jira.site_99]
    url =

...

  1. "http://localhost:8080/jira

...

  1. "
    [source_application.jira.site_99.customfield_11400]
    data_type =

...

  1. "string"
    dimension = true
    name =

...

  1. "TTSEazybiCF"

  2. On the Private

...

  1. eazyBI UI

...

  1. , navigate to Source Data, and click Custom Fields.

    image-20240506-090543.pngImage Added
Note

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,

...

  1. create a new eazyBI calculated field by clicking

...

  1. Add a new calculated

...

  1. field under source data

...

  1. > custom fields for different attributes of your SLA data. 

...

  1. image-20240506-091108.pngImage Added
  2. After the creation of the new field

...

  1. ,

...

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

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

...

  1. image-20240506-091841.pngImage Added
  2. Now you can get a report with the SLA information that you have defined.

...

  1. image-20240506-091906.pngImage Added