Cumulative Agg

Row-based; Calculates a cumulative aggregate based on a relative row window.
Pass in order_by columns to create a row-based look-back or look-forward window.
Example use case: Aggregate all sales for a customer from the beginning of time until this row.
Parameters
Name
Type
Description
Is Optional
aggregations
agg_dict
Dictionary of columns and aggregate functions to apply. A column can have a list of multiple aggregates applied. One column will be created for each column:aggregate pair.
​
order_by
column_list
Column(s) to order rows by when calculating the agg window
​
direction
value
By default, the cumulative agg will calculate by looking 'backward' across all rows, according to the order_by. To override this behavior, use 'forward', and the cumulative will look at each row and all future rows.
True
group_by
column_list
Column(s) to group by when calculating the agg window
True
Example
internet_sales = rasgo.get.dataset(74)
​
ds = internet_sales.cumulative_agg(
        aggregations={
          "SALESAMOUNT": ['SUM', 'MIN', 'MAX']
        },
        group_by=['PRODUCTKEY'],
        order_by=['ORDERDATE'],
        direction='forward'
       )
​
Source Code
RasgoTransforms/cumulative_agg.sql at main · rasgointelligence/RasgoTransforms
GitHub

Name	Type	Description	Is Optional
aggregations	agg_dict	Dictionary of columns and aggregate functions to apply. A column can have a list of multiple aggregates applied. One column will be created for each column:aggregate pair.
order_by	column_list	Column(s) to order rows by when calculating the agg window
direction	value	By default, the cumulative agg will calculate by looking 'backward' across all rows, according to the order_by. To override this behavior, use 'forward', and the cumulative will look at each row and all future rows.	True
group_by	column_list	Column(s) to group by when calculating the agg window	True

Correlation

Datarobot Score

Last modified 7mo ago