Troubleshooting why reports show null or blank values

Follow this step-by-step troubleshooting guide to determine why values don't appear on a chart in Analytics and how to restore missing 0 or blank values.

This article contains these topics:

Step 1: Check if the row selector is hiding data

Step 2: Unhide hidden columns

Step 3: Reset the metric filter range

Step 4: Clear "Hide part of the result" limits

Step 5: Check dashboard and attribute filters

Step 6: Disable Top/Bottom result limits

Step 7: Audit the underlying raw data

Step 1: Check if the row selector is hiding data

In report builder, click Chart configuration .

Select Row selector.

Enable Display row selector. If this setting is off, the chart will hide unselected rows and obscure missing/blank values.

Step 2: Unhide hidden columns

Click Result manipulation .

Select Columns.

Ensure all hidden column toggles are turned off so all data attributes remain visible in your chart output.

Step 3: Reset the metric filter range

Click Result manipulation > Metric filter.

Check if the lower limit on the metric slider excludes low values or 0s.

Adjust the minimum value boundary back to 0 (or your minimum target value) and click Apply.

Step 4: Clear "Hide part of the result" limits

Click Result manipulation > Hide part of the result.

Clear any values entered in the Show first or Show last fields that may be cutting off empty rows.

Click Apply.

Step 5: Check dashboard and attribute filters

Review the top filter bar and left attribute panel in your report builder.

Click into active filter pills to verify that no specific attribute values (e.g., ticket status, group, or tags) are excluded. For details, see Filtering a report.

Step 6: Disable Top/Bottom result limits

Click Result manipulation > Top/bottom.

Uncheck the options for both Top and Bottom filtering.

Click Apply.

Step 7: Audit the underlying raw data

If all filters and result limits have been cleared and expected values still fail to show:

Export the chart's underlying data to CSV to confirm whether missing entries are true nulls or zero values.

Locate sample tickets or records matching your date range and criteria to verify that raw source data exists.

To learn more about reports, see these articles:

Customizing reports

Why do I see blank spaces when reporting on articles?