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.
Counting Blanks
Userlevel 4
- Looker Staff
- 40 replies
-
11 January 2017
Counting rows and then subtracting the inverse (things that aren’t null) may be the easiest route here.
Here’s an example from learn:
https://learn.looker.com/explore/ecommerce/orders?toggle=fil&qid=6lMqg9rjRn5WpNS5Fi3bhG
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
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.