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?