How do I count only non- null values in a row in table calculation

Looker Q&A Looker
1

I have a row of data with some null values, I just want to count the times that the value is not null.

Is there a way to do that easily without writing out a large string?

2 Likes
2

I am having the same challenge is there any way to count NULLs without having to change them to zeros?

Want to avoid changing things to zero as that value has a special meaning for our business.

1 Like
3

Same issue. i would like to count the number of nulls in a row in order to classify the variable

4

To count not null values with positive numeric values:

SUM(IF(my_field >= 0, 1, 0))

or if you also have negative values:

SUM(IF(my_field >= 0, 1, 0)) + SUM(IF(my_field < 0, 1, 0))

With string values:

SUM(IF(LENGTH(my_field) >= 0, 1, 0))

To count null values:

COUNT(my_field) - SUM(IF(my_field >= 0, 0, 1)) - SUM(IF(my_field < 0, 1, 0))