I want to count all the emtyings where the field error is filled in.
The two expressions below didnit work.
What is the correct way to calculate this?
count(distinct(if(match(emptyings_error,'%'), emptyings_id)))
count(distinct(if(match(emptyings_error,'*'), emptyings_id)))