What formula can I use to display positive numbers Only in a visual? 0 and above?

I’m trying to display positive numbers only on a display without using the 0 reference on Y-axis of the line chart, using a calculated field. Like an ifelse statement but I was trying to see if there was another function I should be using?

Hi there e2s,

On a particular visual you can either:

  • Do as you have described and create a new calculated field including only values greater on 0.
  • or alternatively you can configure a filter that is only applied to that visual which filters for greater than 0 on the original field.

Hope that helps!

1 Like