SUM

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. If you would like to predict periods with no interactions, you may use the IS NULL or IS NOT NULL operators.
• For all aggregations, the start time is excluded from the calculation and the end time is included in the calculation.
• The units for the start and end times is days by default but can be specified as months or hours.