Counting Blanks

  • 11 January 2017
  • 3 replies

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:

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