Time To SLA

It is crucial to include service-level agreements (SLAs) and operational-level agreements (OLAs) data in a full and consistent report.

BigQuery Connector for Jira allows exporting any Time To SLA app data from Jira to Google BigQuery for further analytics and building dashboards.

Time To SLA fields are located in a separate tab.

Time to SLA.jpg

The following fields are available for export

Fields Names and IDs

Fields Names and IDs

Indicator (INDICATOR)

Last Status ID (LAST_STATUS_ID)

Notified (NOTIFIED)

Paused (PAUSED)

Expected Target Date (EXPECTED_TARGET_DATE)

Issue ID (TTS_ISSUE_ID)

Last Status Name (LAST_STATUS_NAME)

Origin Status ID (ORIGIN_STATUS_ID)

Pause Duration (PAUSED_DURATION)

Working Duration (WORKING_DURATION)

Issue Key (TTS_ISSUE_KEY)

Last Status Date (LAST_STATUS_DATE)

Origin Status Name (ORIGIN_STATUS_NAME)

Target Status ID (TARGET_STATUS_ID)

Created (CREATED)

Finished (FINISHED)

Last Updated Date (LAST_UPDATED_DATE)

Origin Date (ORIGIN_DATE)

Actual Target Date (ACTUAL_TARGET_DATE)

Updated (UPDATED)