Aggregate Function: Count Distinct Like count, but only counts each distinct value once. Useful for judging data quality (i.e. if you have 600 items with 599 d

Aggregate Function: Count Distinct Like count, but only counts each distinct value once. Useful for judging data quality (i.e. if you have 600 items with 599 distinct values, chances are there's an invalid duplicate; if you have 1 distinct item chances are that column's not of interest; if you have a few distinct values, you have a potential pivot candidate, etc).