Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I've a "Maintenances" table with 2 fields: FailureType and MaintenacesCount.
I wuold like to count all the maintenances where FailureType is null.
I'm using the expression below, which works correctly:
sum(MaintenancesCount) - sum({<FailureType={*}>}MaintenancesCount)
As you see, I get what I need subtracting 2 sets.
Is there a way to describe a set of null values? Something like this (which doesnt work)
sum({<FailureType={null}>}MaintenanceCount)
Regards,
Corrado
You can replace NULL value by the string value - "NULLFailureType"
LOAD
....
if(isNull(FailureType, 'NULLFailureType', FailureType)) as FailureType
....
After that you can use your expression:
sum({<FailureType={"NULLFailureType"}>}MaintenanceCount)