I need to convert the following beast mode to Group by

SUM(served
) OVER (PARTITION BY Physical County
,CABINET
) / Sum(Passed
) OVER (PARTITION BY Physical County
,CABINET
)*100
Answers
-
This calculation uses both aggregated and non-aggregated columns. This may result in duplicate rows and unexpected behavior in charts. See this article for more information.
0 -
I am getting duplicates and unexpected behavior
0 -
Can you just put Physical County and Cabinet on a card and then add a formula (beast mode) as
(SUM(`served`) / SUM(`passed`)) * 100
Your group by is in essence the Physical County, Cabinet.
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
Tried that and the SUM was wrong before the math was good just inconsistent and duplicating
0 -
What about using FIXED? Something like
SUM(`served`) FIXED (BY `Physical County`, `CABINET`) /
NULLIF(SUM(`passed`) FIXED (BY `Physical County`, `CABINET`), 0) * 100** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **1 -
that kinda worked but now I get
An issue has occurred during processing. We are unable to complete the request at this time - 'undefined'
and am unable to save the card
0 -
A bit difficult to visualize without an anonymized data example. I'm thinking there's an issue with NULL.
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0
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
- 667 Datasets
- Visualize & Apps
- 90 App Studio
- 198 Pro-code Components
- 2.6K Charting & Analyzer
- 873 Calculations & Variables (Beast Mode)
- AI & Data science
- 23 Domo AI & AI Chat
- 4 Managing AI
- 18 Jupyter Workspaces
- Automate
- 122 Workflows
- Alerts
- 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
- 118 Community Announcements
- 5K Archive