COALESCE IN LOOKER

[Hannah15]

Hi all.

I am working in LookML. I wrote a measure and Looker automatically adds COALESCE function into SQL. All null values will be displayed as 0. I don't want this. I want that NULL values will be displayed as NULL. Is there any way to do this?

Please help. Thank you so much

[masutaka-pay2]

@Hannah15 This post may be helpful for you.

https://www.googlecloudcommunity.com/gc/Modeling/Displaying-null-values-in-sums/m-p/579502/highlight...

[missjjohn]

Yes, you can override Looker's default behavior of displaying NULL values as 0 by modifying the LookML measure definition. LookML provides flexibility to customize how NULL values are displayed in your visualizations. To achieve this, you can use the is_null parameter in your measure definition. i am sure that will help you Hannah.