Support for SLA subfield data in Sheets

Problem Definition

Currently in the SLA column when data is exported to Either Jira Cloud for Google Sheets (Official) or Jira Cloud for Excel (official) the data is only showing the time metric, either positive if the SLA still has time left or negative if breached. However there is no indication of the status of the SLA such as Active, Paused, Goal met, breached, original time value, etc...

Suggested Solution

Users are looking for the extended data for the SLA goals, and status to be an option as a subfield in the exported data set

Workaround

Define various sheets using JQL to group the SLA variables and show a list of the various states in each sheet as covered in Write JQL queries for SLAs:

• breached()
• everBreached()
• paused()
• completed()
• running()
• withincalendarhours()
• elapsed()
• remaining()

As an example, if you wanted a report to show the differences between all completed SLA's for the "time to first response" metrics that have breached and a list of all completed that have not breached use the following JQL on sheet 1 to show the non breached and completed SLA:

"Time to first response" = completed() AND "Time to first response" != everBreached()

And the second sheet would use the following JQL to show all completed but did not meet the metric goal:

"Time to first response" = completed() AND "Time to first response" = everBreached()