I have data that probably looks something like this:
Date | Label | User |
2023-09-01 | Foo | jdoe |
2023-09-08 | Foo | tvargas |
2023-10-01 | Bizz | jhinks |
2023-07-28 | Bar | jdoe |
2023-08-15 | Bizz | tvargas |
What I'm trying to do is something that in mySQL would be
select label,count(*) from table group by label
and it would get me results like this:
label | count(*) |
Foo | 2 |
Bizz | 2 |
Bar | 1 |
I can't figure out how do this from Looker's Visualization, adding Customer Measures, or customer groups etc.
I can't figure out how to do it from underlying views either.