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

Looker Q&A Looker
1

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.

2

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?