Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have a visualisation which contains a conditional show/hide. I only want the visualisation to surface when there is data in it. Although the visualisation doesn't show when there are zero values in. Which aren't null values. Is there a way to differentiate between zero and null values so the visualisation surfaces when there is a zero value in but not when there is a null value in?
Thanks in advance
If the visualization its a chart in the Presentation tab you need uncheck the Suppress Missing values or Zero values, then it will show the zero values (if they really exits) in the table.
Hi Pablo, thanks for the response. The zero values show in the chart as usual but the problems occurs with the conditional show/hide. In the conditional expression it doesn't seem do be able to differentiate between a zero value and a null value. For example, I want the chart to surface when there is a zero value, but not when there is a null value(No data). At the moment the chart doesn't surface for both zero and null values.
Try using this in the conditional expression: If(Field=0,1,0) or If(Not IsNull(<Field>),1,0).
Dan, if Pablo's last comment was what you needed, please be sure to close out your thread by using the Accept as Solution button on that last post of this, this will give him credit for the help and let other Members know that worked. If you have further questions, please leave an update post with what you still need.
Regards,
Brett