Question

Counting Blanks

  • 11 January 2017
  • 3 replies
  • 1462 views

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.


3 replies

Userlevel 4

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 @colin

Reply