A beast mode where sum is greater than X
Trying to create a Beast Mode where I count distinct customers who have spent more than $100. The issue is I need to sum the revenue amounts because customer spend amounts cross many rows, so looking at just one row won't do it.
when sum(`revenue` > 100) then `customernbr`
-- else 0
Statement works without the 'sum', but I need to look at multiple rows of data to see where customers have in aggregate spent more than $100.
Hopefully this makes a lick of sense.
- 10.7K All Categories
- 13 Getting Started in the Community
- 39 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.5K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 303 Use Cases & Best Practices
- 503 APIs
- 120 Apps
- 48 News
- 753 Onboarding
- 1.2K 日本支部
- Private Company Board