ARR Analysis

This component provides three different ways for calculating and visualizing the ARR:
1. calculating the total ARR in each month and visualizing it in a line plot
2. calculating the total ARR in each month and year, and comparing the years in a line plot
3. calculating the ARR in total and at a customer level in a selected month, e.g. the current month, and creating the interactive tile view for the further analysis.

Options

Columns to be shown at a customer level
Select the columns that will be shown in the tile view for each customer. If you don't want the tile view to be shown, don't select any columns.
Date
Select the column identifying the recurring months within a contract period.
Recurring value
Select the column containing the monthly recurring contract values.
Customer ID
Select the column containing customer ID or other information identifying the customer.
Select date for detailed analysis
Select a month to calculate the total ARR and ARR at a customer level. Your selection will be rounded to the first day of the month.

Input Ports

Icon
The input table containing the recurring values in each month based on the contract period and contract value.

Output Ports

Icon
Output table with the total ARR in each month
Icon
Pivot table with the total ARR in each month and year
Icon
Total ARR for the selected month
Icon
ARR at a customer level for the selected month plus a column identifying if the customer was selected in the interactive tile view

Nodes

Extensions

Links