Count occurrences in a single column with

I have data that probably looks something like this:

DateLabelUser
2023-09-01Foojdoe
2023-09-08Footvargas
2023-10-01Bizzjhinks
2023-07-28Barjdoe
2023-08-15Bizztvargas

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:

labelcount(*)
Foo2
Bizz2
Bar1

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.

0 0 283
0 REPLIES 0
Top Labels in this Space