ARR and MRR by Time-based Cohort

This component shows the (cumulative) ARR or MRR by time and time-based cohort. Cohorts are used to group individual records by the characteristics that they share, which is their starting time in this case. Analysis of cohorts reveals trends and patterns that could not be identified from the individual records.

A time-based cohort for each ID is defined based on the first time when the ID appears in the data.

Four types of churn analysis are possible:
1. The cumulative ARR by time and time-based cohort (stacked area chart)
1. The cumulative MRR by time and time-based cohort (stacked area chart)
2. The ARR in each time-based cohort over time (line plot)
2. The MRR in each time-based cohort over time (line plot)

Required extensions:
- KNIME Expressions
(https://hub.knime.com/knime/extensions/org.knime.features.expressions/latest)
- KNIME Plotly
(https://hub.knime.com/knime/extensions/org.knime.features.js.plotly/latest)
- 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
   Recurring values
   - String or numeric column for the IDs of the records - Column of type Date&Time for the time points of the records - Numeric column for values assigned to each time point and ID

Output ports

1. Type: Table
   SVG image
   If the "Generate image" option is enabled, the cohort chart is provided in SVG format. Otherwise the chart is only shown in the component's interactive view.