
Contributor
2021-05-31
02:46 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Doubt Count Distinct Conditional one condition or another
Helo guys,
I need to count how many distinct clients are buying one category or another category of my products, how do I do that.
count(distinct {<[Brand]={"Blue"} or [Brand]={"Red"}>}[clients code])
I tried to use or and its not calculating.
422 Views
1 Reply

MVP
2021-05-31
04:16 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@giovanna2021 like ?
count(distinct {<[Brand]={'Blue','Red'} >}[clients code])
Regards,
Taoufiq ZARRA
"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "
(you can mark up to 3 "solutions") 😉
Taoufiq ZARRA
"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "
(you can mark up to 3 "solutions") 😉
