is there a way to modify a column anomaly detection such as missing_count. It counts if the column is null or blank or contains the lowercase word 'null'. Our dataset has the word 'Unknown' instead of a null column and we would like a test for a count of Unknown values. Thanks

case

when "Mfg Branch" is null then 1

when trim("Mfg Branch") = '' then 1

when lower("Mfg Branch") = 'null' then 1

else 0

end

Hey @Andy Ritting, The count is calculated here by the rules you've mentioned. You can either contribute a change to the calculation or transform the 'Unknown' values to another model