Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I have created a tree map showing values as well as % share of business done, country wise. What I want is to remove the error message which is displayed below the tree map which says "* the data set contains negative or zero values which cannot be displayed." How do I get rid of this? I read in a thread (link below) that it can be removed using 'calculation condition' in Add ons. However, I am not sure how the expression would be applied in case of 0 values or negatives, including negative percentages. Any suggestions on this?
How do I show a blank when there is negative or zero value?
Best Regards,
Rony
Hi,
Not sure of a way to just remove the message as an option.
The only way i can think of is to get rid of the message is to get rid of the zeros or negative values.
Something like
IF(Sum(Value)>0,Sum(Value))
The reason for the message is to tell you it isn't really giving you a true representation of your data.
Mark
Hi Mark,
Thank you for your response.
Rony
How were you able to show %share and does the chart show data points upon hover?