Running Total Window Function not working
I've got the following BeastMode to calculate the running total over time based on the date. I've utilize window functions before but this one doesn't seem to work. It keeps failing with an error "An issue has occurred during processing. We are unable to complete the request at this time." (It'd be nice if we had better error messages.)
It's a simple line graph with the `dated` field on the x-axis and this beast mode on the y-axis.
SUM(SUM(`totalamt`)) OVER(ORDER BY `dated`)
I know I could utilize other graph types (like the running total card) but this will eventually be combined with other data elements on the same graph.
And ideas to why I might be getting this error?
**Did this solve your problem? Accept it as a solution!**
- 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