Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Goodmorning everyone,
I need to display in a table-like graph, only the records that have the lD empty field (null) You would know someone show me how to do? I entered the dimensions that m affect expression that I use to filter records with null lD?
Thank you Andrew
Hi Andrea, you could put something like this as a dimension:
=IF(IsNull(ID)=-1, ID)
Hope it helps,
Andrés
Hello Andrea, thanks for your kind and polite response.
I tried to insert as a dimension calculated the formula that you have shown me,
but I keep all records 😞
Hi Andrea, no worries. Then maybe in the script you could put something like this:
Table:
Load *
From [your_path]
WHERE isNull(ID)=-1;
And then it should give you just the ID null values
Hope it helps,
Andrés