About EasyMorph Tutorials & Examples Web-help

Window aggregate-functions in EasyMorph (year-to-date, month-to-date)


#1

Is it possible to perform window aggregate functions like sum YTD (year-to-date)? For instance I want to know the accumulated sales volumes over a region up to each day of the year.
My SQL approach would be: SUM(sales amount) OVER (PARTITION BY year, region ORDER BY date)


#2

It is possible using the “Running Total” transformation. See the example below:

month-to-date.morph (2.1 KB)