Lumar's Generate CSV with Exploded Metric export makes it easier to analyse array metrics directly in spreadsheets and BI tools. Array metrics store multiple data points in a single cell, which means they need manual processing before you can filter or sort them. This export unwinds one array metric of your choice into its own dedicated rows and columns, so your data is ready to use straight away.
How to generate a CSV with an exploded metric
Step 1: Open the Export menu
- Navigate to the report you want to export data from
- Click Export in the top right corner of the report
- Select Generate CSV (with Exploded Metric) from the dropdown
Step 2: Choose a metric to explode
- In the dialog that appears, you'll see a list of available array metrics
- Use the Search metrics field to find a specific metric, or scroll through the list
- Select the metric you want to unwind by clicking the radio button next to it
Note: you can only explode one metric per export. If you need to explode multiple array metrics, run a separate export for each one.
Step 3: Generate your export
- Click Generate CSV
- Your file will download automatically
What to expect in your export
The metric you selected will be unwound into its own rows and columns. Each property that was previously nested in a single cell will have its own column, named using dot notation, for example, blocks.type or issues.severity. All other metrics in your export will remain unchanged.
Normal CSV Export