Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am looking to create a table which contains only the tuples that meet a simple if condition:
if(Date=LatestUpdate, 'Yes',NULL)
As a calculated dimension I could select the 'Surpress When Value Is Null' checkbox. How do I achieve the same result when using an expression?
The reason that I did not use a calculated dimension is that it resulted in a memory error.
Thanks,
Alan
Sorry, I don't get it, null values in expressions are filtered by default.
The correct way to reference a null value is through the null function null().
if(Date=LatestUpdate, 'Yes',NULL()) or
if(Date=LatestUpdate, 'Yes')
Hi Daniel,
Thanks for your reply.
I would like to suppress the rows that do not return a 'Yes' as per the above IF condition.
Thanks
Alan
Alan, a row in a table all graph tha has nulls on every expression will be filtered by default, make sure you have the following optin selected.