Description
Calculates the sum of the values in the specified <table>.<column> column starting from <start> days to <end> days. When used in the target field, the time period should be positive (in the future). When used in a temporal filter field, the time period should be negative (in the past).
This operator can only be applied to numerical columns.
Example
SUM(LOAN.AMOUNT, 0, 30)
Training Considerations
- Kumo runs your pQuery over many historic slices of data and across all entities that meet your filter criteria to generate training examples.
- If for a given entity and historic data slice there are no fact rows to aggregate over, the training example label is set to the value 0.
Updated 9 months ago