Question
When building a report, I noticed that null values still show. How can I exclude blank values in my report?
Answer
To exclude blank values in your report follow these steps:
- In the report builder, click Result Manipulation ().
- Select Metric filter.
- Select the checkbox under the metric you want to hide blank values from. Each metric in the report will have this option.
- Click Apply.
If you need to exclude zero values in which 0 is the value returned, and not blank, empty or null, see this article: How do I exclude zero values from my Explore report?