Table vs SQL Data Flows and which functions does Domo not recognize? (I'm confused)

CTBH

Hi,

My CSM informed us that window functions are enabled. I would like to write the following via ETL, or a My SQL dataflow (either way is fine), but I don't know whether to pick a Table or SQL transform, and either one I pick will not accept the following statement.

SELECT *,

sum(a) over (partition by b order by a range between unbounded preceding and current row) 

from my table

What I am ultimately trying to do is create a running sum that resets to 0 when it gets to 30 like in the attached dataset. Like in the attached sample.

30 day count pt 3.xlsx

GrantSmith

The version of MySQL (5.6) that Domo is on doesn't support window functions so you won't be able to do that in a MySQL dataflow. You can do unbounded preceeding and current row within a Magic ETL 2.0 dataflow using the Rank and Window tile to do what you're wanting to do.