Suppress zero values in reporting (pivots & charts)

[Probley]

Is there a way to suppress zero values in reporting? 

1) I have a pivot where I would prefer to have blanks instead of zeros. 

2) I have a chart of status by pipeline where not all statuses apply to each pipeline. I'd like to be able to select which columns show for each pipeline. It seems that zero values are suppressed automatically, but only if it's zero for the status for all pipelines. 

[MiaSrebrnjak · Accepted solution]

Hi @Probley,

Thank you for reaching out to the Community!

I did some testing in my account and I can confirm that this is expected behaviour. It seems it's not possible to show empty values in reports at this time. I found a relevant feature request in our Ideas forum which you could support with an upvote or share your feedback in the comments. 

I also wanted to invite a couple of subject matter experts to this conversation to see if they have any insights or workarounds they could share with us: 

Hi @Dan1, @KTownsend, @Bryantworks, do you have any advice for @Probley? Thank you!

Cheers
Mia, Community Team    

[KamilManzar16]

I came here with same question but nervous to see that this is still under ideas and suggestion. Hope to see any solution soon. 

Thanks.

K

[BérangèreL · Accepted solution]

Hi @KamilManzar16 and thanks for sharing your valuable feedback with us!

Have you tried with the workaround that @karstenkoehler suggests on this similar post "Suppressing zero values and duplicates on a pie chart"?

Also, I’ve noticed a similar idea already present in our Ideas Forum: Exclude months with no value from Report.
To contribute, you can upvote the existing idea and share more details about your specific use case in the comments.

I have added my upvote and will share this feedback internally for more visibility.

Thank you and have a great day!
Bérangère

[MiaSrebrnjak · Accepted solution]

Hi @Probley,

Thank you for reaching out to the Community!

I did some testing in my account and I can confirm that this is expected behaviour. It seems it's not possible to show empty values in reports at this time. I found a relevant feature request in our Ideas forum which you could support with an upvote or share your feedback in the comments. 

I also wanted to invite a couple of subject matter experts to this conversation to see if they have any insights or workarounds they could share with us: 

Hi @Dan1, @KTownsend, @Bryantworks, do you have any advice for @Probley? Thank you!

Cheers
Mia, Community Team    

[Probley]

Thanks @MiaSrebrnjak!