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
@Hannah15 This post may be helpful for you.
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.