Exporting Data
The results of running the SQL query (and the optional R script) of a report can be downloaded any time as a CSV or Excel file for further analysis with other tools or for archival. This functionality is accessed via the "Download CSV" and "Download as Excel" options from the report drop-down menu or from the results section in the query editor.
From the Report editor:
Note: The CSV always contains the "raw" tabular data that are the result of the query execution. The subsequent visualisation may further process / interpret the data (such as the use of 'Cumulative' representation on the Y axis of line/bar charts, so to achieve the same results on the raw data in e.g. Excel, analogous post-processing may be necessary.
Downloading Unlimited CSV
On the Pro and Business plans, you can also enable the options to download "Unlimited" CSV. The results are not limited as usual to the 5000/10000 rows but only in the size of the resulting CSV: 250MB on the Pro plan and 2GB on the Business plan. Hence, the number of rows in the resulting file is
- only limited by the file size if there is no LIMIT clause in the report query.
- limited by the explicit LIMIT clause in the query, if present, e.g. LIMIT 500000 would result in 500000 rows to be in the output (unless this would exceed the file size limit).
This is an optional feature specific to a particular report and can be enabled in the "Advanced" settings tab of the Report Settings:
Which then reveals a new option in the drop-down menu of that report:
The progress is reported in a follow-up dialog. When complete, a download link is presented.
Refreshing Data
When a report is loaded, it first checks if the report data (with the current parameters applied) exists in a temporary server-side cache. If the data no longer exists in the cache, the report query is re-run to obtain the latest data. At any time the cache can be explicitly refreshed by using the "Refresh" action from the report drop-down menu:
Duplicating
Duplicating a report will create a new, independent "clone" of the original report with the same query and visualisation that you can use as a basis for another report:
