Hey All,
MAQL question for you. I have a value t...
# gooddata-uis
Steve Fox
10/17/2024, 4:24 PMHey All,
MAQL question for you. I have a value that has a nullable date field.
How do I make a metric where something isnull??
where label/ESTIMATE_SOLD_DATE.Day is NULL
Steve Fox
10/17/2024, 4:27 PMLooks like this works. Is this a valid option or is this going to cause issues?
where {label/ESTIMATE_SOLD_DATE.year} = NULL
👍🏼 1
j
Julius Kos
10/17/2024, 4:32 PMHi Steve, I believe that is the correct MAQL expression.
s
Steve Fox
10/17/2024, 4:41 PMthank you for confirming, was not easy to find,
Also strange syntax coming from the sql world
<> NULL
IS NULL
etc.
j
Julius Kos
10/17/2024, 5:09 PMThanks for the feedback Steve. I will double-check our documentation and possibly suggest some improvement to make this more visible.
4 Views