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)

Options

Select ID column:

Values that identify each record.

Select value column:

Values that are originally assigned to a time period and that are re-assigned to single time points within the time period.

Select start column:

Start dates of each time period.

Select end column:

End dates of each time period.

Select granularity:

The granularity (months/days) of the single time points that are extracted from the time periods.

Nodes

• Breakpoint8 ×
• Rule Engine Variable8 ×
• Column Selection Configuration4 ×
• Extract Table Dimension4 ×
• Math Formula3 ×
• Show all 26 nodes

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME Javasnippet
• FeatureKNIME Math Expression (JEP)
• FeatureKNIME Quick Forms
• FeatureKNIME Statistics Nodes

Links

• No links available