How to Count or Summarize Null Values

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.

InputData.png

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

Result.png

Attachment