I have a fact that can be Null at times.
I can count the records where it is not null
select count(attribute) where fact > 0.
I am trying to count the amount of records that are null.
I do not see anything in the MAQL guide for that.
Is there a way?
I tried fact = 0 even know I know null is not 0.
I tried fact <=0
Best answer by Iva Gasparekova
I'd suggest to implement the IFNULL statement into some inner metric, to "enforce" the NULL values firstly. You can even multiple it by "1" if the results do not look as expected. Please check my example below:
SELECT IFNULL(SUM(fact), 0)*1
Then you can adjust your main COUNT metric.