I’d like to get a frequency count of values in a column that contains nulls. It seems the nulls records are ignored. Is there a way to do this?
Hi Gavin and welcome to the Community!
Counting nulls can be done in a few ways. For instance, replace nulls with something non-empty, aggregate, and then replace back. Or select only the aggregated columns and use the "Table metadata" action to count nulls in them.
See below an example with both options:
null-count.morph (6.0 KB)
Hi Dmitry,
Thank you! That works a treat.
You're welcome! 