When you want to drill into your data in a metric’s expanded view, you’ll first need to make sure that the column you want to see is selected in Filterable Columns in Edit Metric.
Previously, when drilling into your data, you would only be able to view the columns after a SQL and/or filter transforms were applied. This changed when we introduced the new transform pipeline.
Now, you’ll be able to filter as far back as the data you originally brought into Grow from the API, with two exceptions:
- If you have created a calculated column OR
- If you have used a pivot table.
If your metric doesn’t have either of these transforms, all of the columns that were available when you first pulled your data into Grow will be shown in Edit Metric under Filterable Columns. Even if you add other transforms to your data (grouping, filtering, SQL, etc.), you’ll still have those original columns available to filter.
If you have used a calculated column or pivot table transform, the columns shown in Filterable Columns will be any that were created at or after those transforms were applied.
I have some sample sales data that I want to group by city. After pulling in the data, I can group by city and do a sum aggregate of the purchase amount.
Next, I’ll select my data series and chart labels for my metric. After selecting the data, I can expand the Filterable Columns heading.
The columns shown here are the original columns I pulled in. I can then check the columns I want to be able to see when drilling in in the metric’s expanded view.
Say I want to add a column that calculates the purchase amount before an average sales tax of 6% was applied. To do this, I’d add a calculated column.
After adding that calculated column, the columns available in Filterable Columns are the ones that are shown in my table data after the transform. This will be the data that is shown when drilling into the metric.
Questions? Email us at firstname.lastname@example.org or chat in on the site.