"OVER" function not there in SQL Dataflows - Running totals calculations
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.