I am trying to count the number of times “N/A” appears AND blanks, is there a way to do this in Looker? I am having issues when I say NULL or “” to count the blanks it returns nothing.
Already have an account? Login
Login to the community
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Counting rows and then subtracting the inverse (things that aren’t null) may be the easiest route here.
Here’s an example from learn:
You can also write if() statements to check each row and then sum the result.
thank you for your help!
It would be nice to have a custom measure / measure: count nulls.
It would make things simpler and easier