Sum Count(Distinct) Sales vs Budget
Options

johnlam1
Member
Hello All! I'm trying to do Total Sales divided by Total Monthly Budget in beast mode. The correct output should be $150/$500 but DOMO sum all lines under Budget column that gives out $150/$1300.
I tried Sum(count(distinct 'Store'), 'Monthly Budget') but no luck. Any solution?
Tagged:
0
Answers
-
You could use Magic ETL to group by store and month, and do a sum of Sales and maximum of Monthly Budget (assuming it stays the same the whole month). This would give you an output like this:
A May $120 $300
B May $30 $200
Then in your card just use a beast mode to calculate sales as percentage of budget.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
1
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Data Connections
- 1.3K Connectors
- 309 Workbench
- 17 Cloud Integrations
- Data & ETL
- 2.3K Magic ETL
- 120 SQL DataFlows
- 666 Datasets
- 827 Beast Mode
- Visualize & Apps
- 90 App Studio
- 198 Pro-code Components
- 2.6K Charting & Analyzer
- 46 Calculations & Variables
- AI & Data science
- 23 Domo AI & AI Chat
- 4 Managing AI
- 18 Jupyter Workspaces
- 122 Workflows
- Distribute
- 118 Domo Everywhere
- 284 Reporting
- Manage
- 145 Governance & Security
- 489 APIs
- 11 Add-ins & Plugins
- 13 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 117 Community Announcements
- Automate
- 5K Archive