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!**
Best Answer
-
I figured out the reason was that the windowed function beast mode won't work if the date is being graphed by anything other than "None". This is likely because it's trying to slice / window the data twice or two different ways.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Answers
-
i tried really hard to break my table card ... it still worked.
does the BM work as a table card?
is there any chance of dated being NULL? -- my BM works even with nulls in the dated column.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
Didn't work as a table card. No chance of it being null.
Just doesn't make sense to me because I've done this a bunch of times before and it's a very simplistic beast mode.
If I take out the ORDER BY `dated` section it'll work just fine (and of course not give me a running total).
I've even tried filtering the date on the card to be from a single date and it won't work
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
I figured out the reason was that the windowed function beast mode won't work if the date is being graphed by anything other than "None". This is likely because it's trying to slice / window the data twice or two different ways.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 302 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 633 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 760 Beast Mode
- 62 App Studio
- 42 Variables
- 699 Automate
- 181 Apps
- 457 APIs & Domo Developer
- 51 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive