If you select XLS, XLSX, 'CSV Average', 'CSV Sum', 'CSV Median' or 'CSV Standard Deviation' as export format, 'Group by' field selection will become available. The selected fields will be used to group the report data that will be included in the report. For XLS and XLSX exports, average,sum,median and standard deviation data will be separate sheets in the file, CSV Average, CSV Sum, CSV Median, CSV Standard Deviation export will only contain averages, sum, median or standard deviation 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 or 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 or data.
When you start an export, the screen will automatically switch to Previous Exports tab which shows your recent file exports and their progress. On this tab, you can download the file for a completed export or cancel a running export.
You can close Time in Status page during file export. The export process will keep running in the background. You can open the page later and download your file.
You have 24h to download your export files. Exported files will be deleted after 24h.
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.
XLS file format is limited to 65535 rows and 256 columns. If your data cannot fit within these limits, you should export as XLSX or CSV.
Some pop-up blockers and download blockers cause the export file download to be blocked. If you don't get a file after you select export but also don't get any error messages, check your pop-up blocker and/or download blocker settings .
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 Cloud - Sample Spreadsheet Integration Files