Is there anything equivalent to a SQL count(col) which will only count the non-null values?
Workaround is to create 1/0 columns that can be aggregated via sum() … but it would be nice to have the SQL-style count().
Thanks. John
Is there anything equivalent to a SQL count(col) which will only count the non-null values?
Workaround is to create 1/0 columns that can be aggregated via sum() … but it would be nice to have the SQL-style count().
Thanks. John
Any update on this? I find myself needing to do this calculation all of the time, and not having a simple count()
function available is super frustrating.