Aggregates with NULLs

Other Aggregate Behaviors MIN/MAX Skip NULLs All NULLs: Special Case This quickly shows how complete your data is for different columns. Incomplete Records Finding records with missing data is essential for data quality monitoring. This finds pending orders that can't ship because they're missing an address. Finding Missing Data