How to count rows per field using a measure: count?

[mr_joel]

I have a view that produces data like this:

Item_id	item_description	bucket_id
23	cook book	4
42	apron	2
22	spoon	4
12	frying pan	3
28	cook book	4

I'd like to count the rows per bucket_id. If I was using SQL, it would be count(*) and GROUP BY. The result would look something like this:

bucket_id	count(*)
4	3
3	1
2	1

Ultimately, I'd like to user Looker's Measure: count {} to get the same functionality. That way, users could also click on a bucket_id (or a count(*) and then see the details of everything in the bucket too.

I can't seem to figure this one out.

[skasira59-16573]

Hi mr_joel, I noticed your discussion about the issue you're facing, and I'm experiencing something similar. Have you found any solutions or workarounds yet?