Calculate Recurring Values

This component formats data before analyzing recurring events, such as monthly or annually recurring revenue. In the input table, each record holds a time period, an ID, and some numeric value. These records could be, for example, contracts with different customers. In the formatted output table, each record holds a time point within the time period, ID, and value. This value is calculated by dividing the original value by the number of single time points within the time period.

The granularity of the single time points can be set to "Days" or "Months".

Required extensions:
- KNIME Math Expression (JEP)
(https://hub.knime.com/knime/extensions/org.knime.features.ext.jep/latest)
- KNIME Quick Forms
(https://hub.knime.com/knime/extensions/org.knime.features.js.quickforms/latest)

Input ports

1. Type: Table
   Contracts data
   - Two columns of type Date&Time that define the start and end date of the time period - Numeric or string column for the IDs that identify each record - Numeric column for the values that are assigned to each time period and ID

Output ports

1. Type: Table
   Recurring values
   - Column of type Date&Time for the single time points that have been extracted from each time period - String or numeric column for the IDs of the records - Numeric column for the values assigned to each time point and ID