Hi, Is there a way with faceting or field collapsing to do the SQL equivalent of
SELECT count(distinct(field)) FROM index WHERE length(field) > 0 AND other_criteria i.e. I'm only interested in the total count not the individual records and counts. Cheers, Dan