Export SLA reports

Export SLA reports to continue working with your data outside SLA Time and Report.

You can export:

• SLA Grid reports as XLSX or CSV files

• SLA chart reports as PNG, JPEG, PDF, or SVG files

The Export option becomes available after the selected report data is loaded on the page.

Export an SLA Grid report

Choose a time format

Before exporting the SLA Grid, use the Format menu to choose how SLA durations should appear in the exported file.

Available time formats include:

• h:m:s

• h:m

• M

• HM – Hours and Minutes

• DHM – Days, Hours, and Minutes

• Decimal Hours

• Decimal Days

• Business DHM

• Business Decimal Days

Timer modes:

• Elapsed

• Remaining/Overdue

Goals display:

• Show all goals

• Hide N/A goals

Choose a timer mode

The selected Timer Mode also applies to the exported SLA data.

Remaining/Overdue

Displays how much time remains before the SLA goal is reached. This is the default mode.

Elapsed

Displays how much time has passed since the SLA timer started. To change the mode:

1. Open the Display Format button.

2. Scroll to Timer Mode.

3. Select Remaining/Overdue or Elapsed.

To export data from the SLA Grid:

1. Open the SLA Grid Report.

2. Select the SLA data you want to include in the report.

3. Wait until the data is displayed in the Grid.

4. Click Export.

5. Select Export Excel or Export CSV.

6. In the export configuration window, select the columns you want to include.

7. Click Export to generate the file.

The exported file contains the selected work item and SLA data displayed in the report.

Export an SLA chart

SLA charts can be exported as image or document files. Available formats:

• PNG

• JPEG

• PDF

• SVG

To export a chart:

1. Open the required SLA chart report.

2. Configure the report and wait until the chart data is displayed.

3. Click Export.

4. Select the required file format.

Work with exported data

You can open XLSX or CSV files in spreadsheet applications, including Google Sheets. The exported data can be sorted and filtered using the available spreadsheet tools.

For example, you can use the following SLA values:

• Goal name – the name of the SLA goal

• Goal time – the time limit defined in the SLA configuration

• Remaining time – the time left before the SLA goal is reached

To calculate elapsed SLA time, use:

Goal time − Remaining time = Elapsed time

Сalculation of the SLA time remaining

Also, you can filter data according to the conditions in the program.

Helpful resources & links