You can add the metric filter option to set a floor or ceiling for your results. With a metric filter, you can exclude any one-off or outlying results. A metric filter is displayed for each metric.
You can also add a metric filter to dashboards (see Adding a metric filter).
To add a new metric filter
- In the result manipulation menu (
), select the Metric filter option. - Drag the circles on a metric's line to the numbers you want to use as your floor and ceiling points. Alternatively, click the numbers to enter floor and ceiling values.
- Check the Remove blank values box to exclude any empty results for the chosen metric.
Note: This excludes blanks or null results, not results with a value of zero.
- Click Apply to save the metric filter
- Your filter is added to the Filters panel.
8 Comments
How do I exclude results with a value of zero from the showing up in the result?
Hello Grace,
You will want to make the minimum value for the Metric filter, not zero. Using your lowest value or one would be our recommendation for this.
Best regards.
And how can I Include zero/empty cell?
Metric scale goes from 1 to 284
tickbox is not marked but I miss lines with empty/zero results
Hi Drey Tee,
Thank you for reaching out!
We have a Help Center article that covers How can I include 0 values in Explore reports. You can click Result Manipulation and add your own Result metric calculation.
Please let me know if this helps answer your question.
Hello, I have created a chart and want to remove values less than 5, but also not have them included in my SUM or AVG totals. Currently, if I hide the values, they are still included in these totals. How do I do that?
Hi Sara,
I think this will be better handled in a ticket in order for me to check the chart you have created and troubleshoot this further. I'll create one for you, please lookout for an email notification for this one. Cheers!
Hi,
Is it also possible to use the keyboard to define the range, instead of the drag option? With large numbers it's very difficult to select an exact number, which is exactly what i want to do.
Many thanks!
Bob
Hi Bob,
I'm afraid to say that it's not possible to use your keyboard and enter a value to define the metric result range, but you may try to click on the numbers instead. I certainly understand the intention and the use case in using the keyboard, but unfortunately, it's not possible at this moment.
Best,
Customer Advocacy Team
Please sign in to leave a comment.