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.
Note: Metric filters don't apply to drill in reports. To set a floor or ceiling for drill in results, use a report-level filter instead.
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?
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!
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.
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.
Customer Advocacy Team
I suspect I'm having the same issue as Sarah, I a report with metric filters and it's adding up 1+1 = 12. It seems like Totals ignore the metric filtering altogether?
@..., if you click on the number, a text box appears and you can type in the top and bottom range.
Please sign in to leave a comment.