Hi, I'm stuck on a query for counting distinct users. Say I have data that looks like this:
book, user1 book, user2 book, user1 movie, user1 movie, user2 movie, user3 music, user4 I want to group by the first column and count the number of distinct users for that product. The result would just be: book, 2 movie, 3 music, 1 Is this piggable? Happy Friday! -Kim
