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)
- Type: TableContracts 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