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