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:

  1. In the report builder, click Result Manipulation ().
  2. Select Metric filter.
  3. Select the checkbox under the metric you want to hide blank values from. Each metric in the report will have this option.
  4. 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?

Powered by Zendesk