Troubleshooting why reports show null or missing values

In this troubleshooting guide, you will find out what to do if values do not show on a chart in Analytics. At times, you may see 0 or blank values in your report and can investigate the behavior.

This article contains these topics:

Verify if the row selector is hidden

Check if your columns are hidden

Look into your metric filter

Verify that you are not hiding part of the result

Check that no filter is applied

Verify the Top/Bottom filter

Compare with actual data

Verify if the row selector is hidden

Verify your Chart configuration settings > have Display Row Selector turned on. The row selector may be hidden and only show selected values.

Check if your columns are hidden

In Result manipulation > Columns, ensure that all columns are visible.

Look into your metric filter

In Result manipulation > verify your Metric filter, perhaps you hid part of the result. For example, in this image, the number in the left should be 0 instead of 20.

Verify that you are not hiding part of the result

In Result manipulation > Hide part of the result, ensure you are not hiding data > Apply.

Check that no filter is applied

At the top of the page and on the left side, ensure that you did not add a filter on your data.

Verify the Top/Bottom filter

In Result manipulation > Check the Top/bottom filter > Untick Top and Bottom > Apply.

Compare with actual data

Finally, if you still see missing values, verify your sources of data. For example, open sample tickets and compare the results with your report.

To learn more about reports, see these articles:

Customizing reports

Why are some days missing from my reports in Explore?

Why do I see blank spaces when reporting on articles?