In this page

What is Time to SLA?

(supported since Better Excel Exporter 3.4.0)

Time to SLA is a popular choice to implement Service Level Agreements (SLAs) on Jira issues. It helps to set up, track and measure SLAs based on issue events (status change, resolution, reopen, etc.).

Time to SLA integration features

  • You can export the Time to SLA specific custom field types like Time to SLA, Overdue Status, SLA Indicator, SLA Overview, TTS - Time String and TTS - SLA Dates to Excel.

(Need more features? Tell us in a support ticket!)

Time to SLA integration vs. the Time to SLA built-in Excel exports

You may want to ask: if Time to SLA has a built-in Excel export feature, why would you use another app for the same?

While the Time to SLA built-in Excel exports may be sufficient for basic use cases, the Better Excel Exporter integration is more powerful in, at least, these:

If any of these are important for you, give it a try.

Tutorial video

This short video shows how simple it is to export Time to SLA data to Excel:

Export samples

Issues with Time to SLA fields

This basic Excel export (created using the default issue-navigator.xlsx template) contains one column of each Time to SLA custom field type. The idea is to demonstrate the default SLA export format that you can customize to your needs.

jira-time-to-sla-export.xlsx

Configuration

Exporting Time to SLA custom fields

There is nothing to do. Better Excel Exporter will automatically recognize the Time to SLA managed fields and export them accordingly.

Configuring the export format for Time to SLA custom fields

While some Time to SLA custom fields display simple values (like a single date), some others display fairly complex ones (like a complete SLA history). Complex values are exported to Excel cells using the structured left-indented text format that we found the most intuitive:

[Time in "To Do"]
	Issue met SLA
	1 hours, 50 minutes, 29 seconds
[Time in "In Progress"]
	Issue met SLA
	11 hour, 34 minutes, 7 seconds
[Time in "Waiting for customer"]
	SLA is running
	1 hour, 56 minutes, 18 seconds

You can freely customize the output format by modifying these methods in the field-helper-tool.groovy script:

// field-helper-tool.groovy

private def overdueStatusToString(def ttsFieldValue)
private def slaIndicatorToString(def ttsFieldValue)
private def slaOverviewToString(def ttsFieldValue)
private def timeToSlaToString(def ttsFieldValue)

Not only you can use and modify the information you can see in the original implementation of these methods, you can also access additional information. Those are specific to the custom field type.

For example, to display the time in milliseconds for the Time to SLA custom field values, change the it.timeToSlaAsString expression to it.timeToSla in the timeToSlaToString() method. For a comprehensive guide, please refer to the official Time to SLA developer documentation

Learn more about Time to SLA