Troubleshooting why reports show null or blank values

<p>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.</p><p>This article contains these topics:</p><ul>
<li data-list-item-id="edf372d454839d81671f41f818c51ca87"><a href="#h_01JBCHM83TCP0KTBXNKR7R6P5A">Step 1: Check if the row selector is hiding data</a></li>
<li data-list-item-id="e4aaade07a6220c9f21866c59a0244381"><a href="#h_01JBCHMBD8B8QCM4Z21DTEZHN2">Step 2: Unhide hidden columns</a></li>
<li data-list-item-id="e9dd3176754f0f1d0d5ce8eafefcec81f"><a href="#h_01JBCHMGF0PQ4HTEX3Q6F4KASK">Step 3: Reset the metric filter range</a></li>
<li data-list-item-id="ea825eb3fd8ab0b283339ea006fb62603"><a href="#h_01JBF1V6B3ZXF7PRTY2VQ7J23Q">Step 4: Clear "Hide part of the result" limits</a></li>
<li data-list-item-id="e83140acb9d225751a1b8ed0d09162bc5"><a href="#h_01JBF21PQYJ72BYWVQ3612SEYH">Step 5: Check dashboard and attribute filters</a></li>
<li data-list-item-id="e05fa7b44de41f74a605ccce29ef8378e"><a href="#h_01JBCHMN317DX8B4MZ05V30DW4">Step 6: Disable Top/Bottom result limits</a></li>
<li data-list-item-id="e8720392cb2349e1223a562d004fffbb8"><a href="#h_01JBF2ZPXX8PYSE6X0XC4GFBX0">Step 7: Audit the underlying raw data</a></li>
</ul><h3 id="h_01JBCHM83TCP0KTBXNKR7R6P5A">Step 1: Check if the row selector is hiding data</h3><ol>
<li data-list-item-id="e9f6b192c91b1bb9d0bd8094eeb27415c">In report builder, click <strong>Chart configuration</strong> <img class="wysiwyg-image" style="height: auto;" src="https://zen-marketing-documentation.s3.amazonaws.com/docs/en/Explore_chart_configuration.png" alt="Chart configuration icon" id="topic_zhb_fsp_my__image_amz_vpr_my">.</li>
<li data-list-item-id="e981a8c10582870e129204818593e11cc">Select <strong>Row selector</strong>.</li>
<li data-list-item-id="e68f638d802ec4dd14131f9736c0a45ce">Enable <strong>Display row selector</strong>. If this setting is off, the chart will hide unselected rows and obscure missing/blank values.</li>
</ol><p><img src="https://support.zendesk.com/hc/article_attachments/11015936538394" alt="Row selector.png" width="308" height="403"></p><h3 id="h_01JBCHMBD8B8QCM4Z21DTEZHN2">Step 2: Unhide hidden columns</h3><ol>
<li data-list-item-id="e573da9bb6ab8906d9f1cbcab8995d625">Click <strong>Result manipulation</strong> <img class="wysiwyg-image" style="height: auto;" src="https://zen-marketing-documentation.s3.amazonaws.com/docs/en/Explore_result_manipulation.png" alt="Result manipulation icon" width="16" id="topic_ygm_fc2_zsb__image_zc5_xb2_zsb">.</li>
<li data-list-item-id="e2907f0c199dccd8390f361a59f8caabe">Select <strong>Columns</strong>.</li>
<li data-list-item-id="e299ef5caa4d2b05e75f6e724115eb33d">Ensure all hidden column toggles are turned off so all data attributes remain visible in your chart output.</li>
</ol><p><img src="https://support.zendesk.com/hc/article_attachments/11015910895514" alt="Result manipulation.png" width="308" height="397"></p><h3 id="h_01JBCHMGF0PQ4HTEX3Q6F4KASK">Step 3: Reset the metric filter range</h3><ol>
<li data-list-item-id="ec551e74edce4ad85f1789df6fd712ac6">Click <strong>Result manipulation</strong> <img class="wysiwyg-image" style="height: auto;" src="https://zen-marketing-documentation.s3.amazonaws.com/docs/en/Explore_result_manipulation.png" alt="Result manipulation icon" width="16" id="topic_ygm_fc2_zsb__image_zc5_xb2_zsb"> &gt; <strong>Metric filter</strong>.</li>
<li data-list-item-id="e68976e4c86c3a213ca868a3d0fcdeb45">Check if the lower limit on the metric slider excludes low values or 0s.</li>
<li data-list-item-id="ee4eaf69b24510a3f86761d9bdb42bfe5">Adjust the minimum value boundary back to <strong>0</strong> (or your minimum target value) and click <strong>Apply</strong>.</li>
</ol><p><img src="https://support.zendesk.com/hc/article_attachments/11015936538650" alt="Metric filter.png" width="308" height="333"></p><h3 id="h_01JBF1V6B3ZXF7PRTY2VQ7J23Q">Step 4: Clear "Hide part of the result" limits</h3><ol>
<li data-list-item-id="e598a40647128b220c43abe9826058124">Click <strong>Result manipulation</strong> <img class="wysiwyg-image" style="height: auto;" src="https://zen-marketing-documentation.s3.amazonaws.com/docs/en/Explore_result_manipulation.png" alt="Result manipulation icon" width="16" id="topic_ygm_fc2_zsb__image_zc5_xb2_zsb"> &gt; <strong>Hide part of the result</strong>.</li>
<li data-list-item-id="e021493d4bbc274f585d1b49ce3d43433">Clear any values entered in the <strong>Show first</strong> or <strong>Show last</strong> fields that may be cutting off empty rows.</li>
<li data-list-item-id="eae2d6418b0ebd346d23a5c7778e13e88">Click <strong>Apply</strong>.</li>
</ol><p><img src="https://support.zendesk.com/hc/article_attachments/11015936538778" alt="Hide.png" width="308" height="335"></p><h3 id="h_01JBF21PQYJ72BYWVQ3612SEYH">Step 5: Check dashboard and attribute filters</h3><ol>
<li data-list-item-id="e57bccefed3d52bb31361aa3997e38873">Review the top filter bar and left attribute panel in your report builder.</li>
<li data-list-item-id="ed97daec819f7a6dc68c8eda1602998a1">Click into active filter pills to verify that no specific attribute values (e.g., ticket status, group, or tags) are excluded. For details, see <a href="https://support.zendesk.com/hc/en-us/articles/4408825475354-Filtering-a-report" target="_blank" rel="noopener noreferrer">Filtering a report</a>.</li>
</ol><p><img class="wysiwyg-image-resized" style="aspect-ratio: 1662/1322; width: 94.48%;" src="https://support.zendesk.com/hc/article_attachments/11015936538906" alt="Filter rows in analytics" width="1662" height="1322"></p><h3 id="h_01JBCHMN317DX8B4MZ05V30DW4">Step 6: Disable Top/Bottom result limits</h3><ol>
<li data-list-item-id="ebbfd88ff3aebb350736d75c5cf95047f">Click <strong>Result manipulation</strong> <img class="wysiwyg-image" style="height: auto;" src="https://zen-marketing-documentation.s3.amazonaws.com/docs/en/Explore_result_manipulation.png" alt="Result manipulation icon" width="16" id="topic_ygm_fc2_zsb__image_zc5_xb2_zsb"> &gt; <strong>Top/bottom</strong>.</li>
<li data-list-item-id="ee762304cb3f0c66e615e146642eca7ca">Uncheck the options for both <strong>Top</strong> and <strong>Bottom</strong> filtering.</li>
<li data-list-item-id="e58aab88b6e0e748af23c4e751c250cec">Click <strong>Apply</strong>.</li>
</ol><p><img src="https://support.zendesk.com/hc/article_attachments/11015910895642" alt="Top bottom.png" width="308" height="333"></p><h3 id="h_01JBF2ZPXX8PYSE6X0XC4GFBX0">Step 7: Audit the underlying raw data</h3><p>If all filters and result limits have been cleared and expected values still fail to show:</p><ol>
<li data-list-item-id="efbe872af72c2ca024e3139edc46ee2d1">Export the chart's underlying data to CSV to confirm whether missing entries are true nulls or zero values.</li>
<li data-list-item-id="ecc3081dea8f88cd5e56a8544c1638ae1">Locate sample tickets or records matching your date range and criteria to verify that raw source data exists.</li>
</ol><p>To learn more about reports, see these articles:</p><ul>
<li data-list-item-id="ead5f9e7e5eec6571713c8746752f4954"><a href="https://support.zendesk.com/hc/en-us/articles/4408839246618-Customizing-reports" target="_blank" rel="noopener noreferrer">Customizing reports</a></li>
<li data-list-item-id="e396aeb5ffd06408cde654076a50d240a"><a href="https://support.zendesk.com/hc/en-us/articles/4434999444250-Why-do-I-see-blank-spaces-when-reporting-on-articles" target="_blank" rel="noopener noreferrer">Why do I see blank spaces when reporting on articles?</a></li>
</ul><style>
.ai-only {
position: absolute !important;
width: 1px !important;
height: 1px !important;
padding: 0 !important;
margin: -1px !important;
overflow: hidden !important;
clip: rect(0, 0, 0, 0) !important;
white-space: nowrap !important;
border: 0 !important;
}
</style><div class="ai-only" aria-hidden="true"><details><summary>THIS SECTION IS AI CONTENT. DON'T EDIT OR DELETE.</summary><h2 id="h_01KXKTHC3E4YNEY33SXE8DTN4M">How do I fix empty charts in Explore or reporting? Why does my report show "0" or blank values? How do I troubleshoot "null" or "missing values" in analytics or reporting?</h2>
<p>You can investigate the behavior when values do not show on a chart in Explore or analytics or reporting. Use these steps to troubleshoot the report:</p>
<ol>
<li data-list-item-id="e2306953f27e85163ff096c8b50c8daee">Verify if the chart hides the row selector. In <strong>Chart configuration</strong> settings, turn on <strong>Display Row Selector</strong> because a hidden row selector only shows selected values.</li>
<li data-list-item-id="e03aa0549fc68ae6bf5c8c816f9cb6e4b">Check if the report hides your columns. In <strong>Result manipulation</strong> &gt; <strong>Columns</strong>, ensure that all columns are visible.</li>
<li data-list-item-id="e541c8c4d2c56b287c5868944c11e15fc">Look into your metric filter. In <strong>Result manipulation</strong>, verify your <strong>Metric filter</strong> to ensure you do not hide part of the result.</li>
<li data-list-item-id="eaf185a063fa4d3027d2ba4ed907e8297">Verify that you do not hide part of the result. In <strong>Result manipulation</strong> &gt; <strong>Hide part of the result</strong>, ensure you do not hide data and select <strong>Apply</strong>.</li>
<li data-list-item-id="e01f92bd3a5cce8f72eb7b2bd633ada26">Check that you apply no filters. At the top of the page and on the left side, ensure that you do not add a filter on your data.</li>
<li data-list-item-id="e2539815cea9a127584c554e54041ca8a">Verify the Top/Bottom filter. In <strong>Result manipulation</strong>, check the <strong>Top/bottom filter</strong>, untick <strong>Top</strong> and <strong>Bottom</strong>, and select <strong>Apply</strong>.</li>
</ol>
<h2 id="h_01KXKTHC3E9HY81NC21MVP61YW">How do I verify chart data against actual tickets or customer conversations? What should I do if chart values remain missing after troubleshooting? How do I compare report results with sample requests or tickets?</h2>
<p>If missing values remain, verify your sources of data. Open sample tickets or requests in Support or your help desk or ticketing system and compare the results with your report.</p></details></div>