Calculate sum of x over (order by y)
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
Can someone show me how to do this in magic etl or a beastmode?
- 10.6K All Categories
- 13 Getting Started in the Community
- 31 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.4K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 301 Use Cases & Best Practices
- 500 APIs
- 118 Apps
- 48 News
- 753 Onboarding
- 1.1K 日本支部
- Private Company Board