It would be really nice if there were a Looker way to group by one dimension, count the number of rows, and then count how many group have each result. In MySQL that’s
select c, count(*) from( select foo, count(*)c from t group by foo )t1 group by c
but making a derived table every time I want to do this is annoying. It would be good if there were some feature in Looker that enabled this. I’m not sure what form (UI) such a feature should take, though.