Icon

Calculating Annually Recurring Revenue

Calculating Annually Recurring Revenue
This workflow calculates and visualizes ARR Calculate total ARR for each month, and plot the ARR over time in a line plot Calculate total ARR for each month and year, and plot the ARR from January to Decemberseparately for each year Calculate total ARR in a selected month, e.g. the current month Demo data From contracts to monthlyrecurring values From contracts to monthlyrecurring values Demo data From contracts to monthlyrecurring values Demo data Read demo dataARR by year and monthSum up recurring values by month and yearYearMonthPlot ARR over timex12 for ARRx12Sum up recurring valuesx12 for ARRSum up recurring values for each monthRead demo dataRead demo datacurrent month Excel Reader (XLS) CalculateRecurring Values Line Plot (Plotly) Pivoting Extract Date&TimeFields Line Plot (Plotly) Math Formula(Multi Column) Math Formula GroupBy Math Formula(Multi Column) GroupBy CalculateRecurring Values Excel Reader (XLS) CalculateRecurring Values Excel Reader (XLS) Date&Time-basedRow Filter This workflow calculates and visualizes ARR Calculate total ARR for each month, and plot the ARR over time in a line plot Calculate total ARR for each month and year, and plot the ARR from January to Decemberseparately for each year Calculate total ARR in a selected month, e.g. the current month Demo data From contracts to monthlyrecurring values From contracts to monthlyrecurring values Demo data From contracts to monthlyrecurring values Demo data Read demo dataARR by year and monthSum up recurring values by month and yearYearMonthPlot ARR over timex12 for ARRx12Sum up recurring valuesx12 for ARRSum up recurring values for each monthRead demo dataRead demo datacurrent monthExcel Reader (XLS) CalculateRecurring Values Line Plot (Plotly) Pivoting Extract Date&TimeFields Line Plot (Plotly) Math Formula(Multi Column) Math Formula GroupBy Math Formula(Multi Column) GroupBy CalculateRecurring Values Excel Reader (XLS) CalculateRecurring Values Excel Reader (XLS) Date&Time-basedRow Filter

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: KNIME
Created at: 2018-12-03
On NodePit since: 2021-04-14
Last update: 2024-04-25
Created with KNIME version: v4.2.1
Tags: financeARR

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!