Exclude Items with Zero or no Metric Data
‘Exclude Items with Zero Metric Value’ is a feature that applies to Date and Text type fields for Display by or Group by options. It filters out empty records from the x-axis.
This option, when activated for the display field of your choice, does not alter the total results of your charts but enhances the visual appearance of the x-axis items by removing the gaps.