Unique Count based on Revenue Amount
I am working on a beast mode to count the number of contacts that have generated greater than $100k in revenue. I've tried the beast mode below, but it's only pulling null values. I kind of expected this to not work, but had to give it a try.
(CASE when `Revenue Amount (Global)` > 100000 then COUNT(DISTINCT `Contact ID`) end)
Part of the problem, I think, is that the beast mode isn't aggregating the revenue by contact. Our source data brings in every line of on every invoice so it can be thousands of rows even for one contact. However, I'd like to think that there's a beast mode out there that would help.
Let me know if there's any additional information that would be helpful. Any assistance would be greatly appreciated!
- 7.3K All Categories
- 13 Getting Started in the Community
- 134 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 52 Domo Everywhere
- 2K Charting
- 994 Ideas Exchange
- 894 Connectors
- 236 Workbench
- 342 APIs
- 76 Apps
- 18 Governance & Productivity
- 233 Use Cases & Best Practices
- 49 News
- 473 Onboarding
- 570 日本支部