Count distinct by user within a measure,

Hello,

I am new to Looker and I may be on a wrong track but I created a view which is made up of 3 columns: id, seller, and sold_date.
What I need to do is create a measure that would give me a count of distinct days for each seller.
What I have is:

measure: Count_DaysWorked {
type: count_distinct
sql: ${Sold_date} ;;
value_format_name: id
}

This, however, I believe would only give me the number of distinct sold days but not necessarily by each seller.
Am I right and if so, how do I specify that I want this count to be by some other column - seller in my case?

Thanks!

1 2 7,882
2 REPLIES 2

it looks to me like this is what you want:

measure: Count_SellerDaysWorked {
type: count_distinct
sql: ${Sold_date} || ${Seller} ;;
value_format_name: id
}

Thank you so much Quinn!
This appears to be working exactly the way I was hoping it would!

Thanks!

Top Labels in this Space
Top Solution Authors