How can i get total no of non null records column wise?

[#1]

Hi All,

I am trying to create a ETL testing dashboard . I am looking for ways to create to no of non null& null record count column wise for tables.

please advise me

[sunny_talwar]

Try this:

Dimension:

$Field

This can be used to calculate number of nulls:

$(=concat('if($Field=' & chr(39) & $Field & chr(39) & ',nullcount([' & $Field & '])', ',') & concat(right($Field&')',1)))

Subtract the above from Number of records to find non null.