Want to know more about Grow’s filter and drill features? This article will give you a closer look into how it works.
You are as filterable or drillable as the things you give your metric. The more you give Grow to filter, the more you’ll be able to filter.
You can filter and drill back to the data you call in from the API, with two exceptions:
- If you have used a calculated column OR
- If you have used a pivot table.
When using a calculated column or pivot table, you will be able to filter those columns that exist at or after you applied those two transforms.
For all other transforms, you will be able to filter back to the last "checkpoint"---either the original data you pulled from the API or a pivot table or calculated column.
If you want more details, check out this article.
When you get into Edit Metric, if there is a certain field you want to be able to filter on, make sure that box is checked under the Filterable Columns heading.
The nice thing about filtering is that even if the metric on your dashboard doesn’t show certain fields, you’ll be able to filter on them if they’ve been selected.
While drilling into your data only gives some actionable insight, it does allow you to ask questions about what is happening. Those questions will then lead into greater insights to your company.
For example, let’s say you are looking at your company’s sales and you notice it spiked one day. Drilling would let you look into it and figure out why they spiked. You can find the value of the sales closed that day, the sales rep that closed them, among other useful information.
With both filtering and drilling, if you want to be able to filter off a certain field, make sure it is part of the report that builds up your final metric. Drilling is based on the order of operations above and then whatever filters you apply in Expanded Mode. If you just expand the metric, don’t apply any filters, then drill into a data point, you will see all of the data for that specific point.
Here’s a quick insight into what filter and drill enables you to do:
- It levels the playing field in your business. The numbers for some reps or sales or other metrics may look large, but filtering and drilling will allow you insights into what is actually happening.
- You don’t have to pack a whole lot of data into one metric. Just make sure it is filterable, and even if it’s not displayed on the metric, you will still be able to see what’s happening.
- You will get to the core a lot faster. Before filter and drill, you may have had to build out many metrics in order to see things you needed to see. Now, with a couple clicks of the mouse, you can quickly answer the questions that you have.
- It empowers even a very basic-level user to answer a lot of questions about the data. It is easy to see, to understand, and then to talk about the score with your company.
Haven't enabled filter and drill on a metric yet? Here's how.
Questions about using filter and drill? Email us at firstname.lastname@example.org or chat in on the site and we’ll be happy to help.