How to Count or Summarize Null Values

Gido

Goal

Count or summarize <null> values.

Background

GROUPCOUNT counts all records in one group, so null or blank values need to be counted separately first.

Learn

To see a count of null or blank values, add an additional column to your input data and where you check if a value ISNULL or ISBLANK.

After that you can GROUPBY key and condition and GROUPCOUNT the values.

Attachment

0 comments

Please sign in to leave a comment.