Export Metrics Data

Export Data

You can export data as CSV of the chart output from any chart widget in Transform. Use the three dots on the top right-hand corner and select "Export CSV". This will download a CSV of the output to your browser.

Exporting with Group By Applied

By default and for metrics based on additive measures (measures that use an aggregation type of sum or sum boolean), we will show top 25 dimensions on the chart. The remaining will be summed and grouped into an "Other" category so we do not crowd the chart. You can optionally select "All" in the dropdown next to the grouping menu to see all dimensions or select a specific number of dimensions to show. When you export data as CSV while using a group by, the CSV modal will give you an option to export all the data (without the dimension limit), or to export exactly what the graph shows.

Copying Last Day's Values

The same menu that contains the export CSV also has an option called "Copy Last Day's Values". This simply copies out the latest day of data. If there is a grouping applied, it will copy out each respective dimension and value in list form with the latest date. If there is no grouping applied, it will copy out a single day of data with the date. The copy is meant to allow for easy pasting into a tool like Google Sheets or Excel.