I’m wondering whether its possible to prevent a report’s data labels from displaying zero-values (e.g. “US$0” - underlined in red in the screenshot below).
I’ve tried filtering out zero values and changing the axes minimums, but neither has worked.
For context, this is a custom report builder report displaying amount sums by close date, which is ‘broken down by’ a geographic variable.
Appreciate any ideas/suggestions!
Hi @OMueller7
If you click into the zero values, what sort of deals are you seeing then?
Which amount/value property are you displaying in the report?
Are you filtering out deals that don’t have any values for that property?
Frank
Hi @franksteiner79, appreciate the response!
1. clicking on zero-values gives me a: “There is no data to show in this time frame. Try changing the date range.” message.
2. I am displaying the ‘Forecast amount’ property and am filtering out amounts <1 (filtering by ‘is known’ doesn’t change things).
I’ve been able to replicate the zero data labels by graphing deal counts and normal deal amounts and using the ‘Break down by’ a property. This seems to force the report into displaying data labels each sub-category of said property (e.g. each geographic region), even if there is no data for said sub-category.
