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!
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!