Calculate sum of x over (order by y)
Hi!
I have tried the following script in beastmode and it said successful after validating it but when I go to apply to any table, it shows an error, "An issue has occurred during processing. We are unable to complete the request at this time."
My Users column is an integer and my Section Master column is text.
SUM(`Users`) over (order by `Section Master`)
If it didn't work, why did it say successful?
Then I tried using mySQL and still nothing
SELECT `Users`, `Section Master`
SUM(`Users`) OVER (ORDER BY `Section Master`) AS usersbysection
from `bottom_25_simple_output_ranked`
Can someone show me how to do this in magic etl or a beastmode?
Best Answer
-
In your Beast Mode you need to wrap your SUM() in another SUM() because of how Domo interprets the function.
SUM(SUM(`Users`)) over (order by `Section Master`)
Here's a good video which describes this in more detail.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Answers
-
In your Beast Mode you need to wrap your SUM() in another SUM() because of how Domo interprets the function.
SUM(SUM(`Users`)) over (order by `Section Master`)
Here's a good video which describes this in more detail.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 278 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 89 SQL DataFlows
- 556 Datasets
- 2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 569 Beast Mode
- 11 App Studio
- 27 Variables
- 578 Automate
- 140 Apps
- 414 APIs & Domo Developer
- 23 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 351 Distribute
- 91 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 92 Manage
- 89 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 85 Community Announcements
- 4.8K Archive