I am not able to perform "window" functions (specifically "over" function ) in a SQL Dataflow that I have created. Also - there were no dropdowns that suggest "OVER" exists as a function within Domo for SQL dataflows.
It is related to "Partition" and is used in Running Totals. Partition is there, but there is no "OVER" function available. I keep getting a syntax error in my dataflow because of this - I have tested out SQLFiddle and in other platforms where it works properly.
Very important function for calculating running totals as described here
SQL Fiddle - http://sqlfiddle.com/#!15/c9e0d/5
This is urgent and needs to be fixed asap