Looker Connect Training

Help Center

Documentation

Community

Cloud Certifications

Solved

Replace 0 with null on column

  • 29 March 2022
  • 2 replies
  • 551 views
sofypond

Hello,

I am trying to change some zero values with null because they show on the graph and they look ugly. I have tried with the function nullif but it says it is not supported when I try to create a table calculation. Is there any way to change those zeros by nulls as the data is not available? Thanks!

 

Thanks!

icon

Best answer by Shru 12 June 2022, 13:05

View original

2 replies

Shru

Hi, this worked for me as a table calculation. You can give it a try.

if(coalesce(${yourmeasure},0)=0,null,${yourmeasure})

sofypond

Thanks! It worked :)

Reply


Terms of Service