All data included in the report can be exported in XLS, XLSX or CSV file formats.
Exporting
To export data simply click on the export icon and the export window will pop-up with New Export tab selected. In this tab you can select the file format and start export.
Once the file export is started, the window will automatically switch to Previous Exports tab. This tab lists all the running and previously completed file exports.
Using this tab you can follow the progress of your file export and download your file once the file export is complete.
Previous Exports tab also allows you to abort a running file export or see the error message if your file export fails for some reason.
Since the file export runs asynchronous; you can start an export, close your computer and download your file some time later.
Aggregation
If you select one of XLS, XLSX or 'CSV Average' file export formats in New Export tab, Group by field selection will become available.
The selected fields will be used as grouping fields for average durations or counts that will be included in the report.
For XLS and XLSX exports, average data will be a separate sheet in the file, CSV Averages export will only contain averages in the file.
- You can select system or custom fields on the issue as grouping fields.
- Some fields (like issue key or Summary) or some field types (like multi line text fields) are intentionally excluded from this list since grouping by those fields do not make sense.
- Date fields will be available as 5 different options as you can select the Year, Month, Week, Day, Hour part of the date field.
- If you do not select any fields, overall averages will be calculated and included in the report as a single row of data.
Data sheet in exported Excel file
Averages sheet in exported Excel file
Values are exported to Excel with the format they are displayed on screen, (like HH:mm:ss, etc...)
Depending on the size of data, the preparation of the export file can take several minutes.
Some pop-up blockers and download blockers cause the export file download to be blocked. Check your pop-up blocker and/or download blocker settings if you don't get a file after you select export.
Spreadsheet Automation Samples
You can also pull data from Time in Status REST API directly into your spreadsheet to automate reporting. For details, see: TiS Server and Data Center - Sample Spreadsheet Integration Files