Analyze your metrics continuously with the Rolling Window

The Rolling Window gives you an alternative way to read your indicators: a continuous analysis, in the form of an X-month moving average, instead of a view split by calendar month. Ideal for analyzing your momentum, detecting trend inflections, and neutralizing calendar-related edge effects.

What is the Rolling Window?

The Rolling Window (or sliding window) means calculating a KPI over the last X months, updating that window continuously. In practice, it is an [X]-month moving average for level indicators (and a rolling sum for flows — see below).

A few possible examples:

• Average MRR or ARR over the last 3 rolling months
• Churn in value over the last 6 rolling months
• Net growth over the last 12 rolling months

The goal: a smoother reading, neutralizing seasonality, that highlights structural trends.

Why use the Rolling Window?

1. Smooth out monthly volatility

Metrics that are sensitive to seasonality or other effects (churn, expansions, new customers…) become more stable.

2. See trends more clearly

The Rolling Window reveals real traction, even if your activity varies a lot from one month to the next.

3. Compare trajectories on a more consistent basis

Comparing "the last 3 rolling months" year over year is often more relevant than a Q1 or Q4.

4. Better understand seasonality, momentum, and weak signals

Ideal for anticipating trend shifts.

How to use the Rolling Window in Fincome?

The Rolling Window is available from any chart, directly in the Analytics interface.

To enable it:

1. Open the chart of your choice (MRR or ARR, growth, churn, revenue…).
2. At the top left of the chart, click the Rolling window button, right next to the period selector.
3. Choose the sliding window you want.

Default options: 3 rolling months, 6 rolling months, 12 rolling months.

Custom option: you can define your own window. Its unit follows the period granularity selected on the page: in a monthly view it is expressed in months, in a quarterly view in quarters, and in an annual view in years.

Once enabled, Fincome automatically recalculates your KPIs according to the selected rolling period.

How does Fincome calculate the Rolling Window?

The Rolling Window applies a different logic depending on the nature of the metric.

Stock KPIs → moving average

For level indicators (MRR or ARR, number of subscribers, ARPA, LTV…), Fincome calculates the moving average of the values over the X-month window.

Example: 3-month moving average of MRR or ARR

Each value in the right-hand column is the average of the last three months: in March, (100,000 + 110,000 + 105,000) ÷ 3 = €105,000; in April, (110,000 + 105,000 + 120,000) ÷ 3 = €111,667; and so on. The window "slides" by one month on each row, which smooths out monthly jolts while following the underlying trend.

Flow KPIs → rolling sum

For movements (recognized revenue, new MRR or ARR, expansions, contractions, churn in value, new customers, reactivations), Fincome adds up the values over the window. These flows are summed independently of one another: there is no netting between movement types.

Churn and retention rates (GRR / NRR) → cohort-based calculation

Churn and retention rates in Rolling Window mode are not an average of the monthly rates. They are calculated by cohort: Fincome starts from the base of customers present at the beginning of the window (X months ago) and measures what became of that base's revenue by the end.

Over a 12-month window, starting from the MRR or ARR of the cohort present 12 months ago:

• Churn rate = churn in value of that cohort over the window ÷ starting MRR or ARR of the cohort.
• NRR = (starting MRR or ARR + expansions − contractions − cohort churn in value) ÷ starting MRR or ARR.
• GRR = (starting MRR or ARR − contractions − cohort churn in value) ÷ starting MRR or ARR (expansion is excluded).

New customers and reactivations that occurred during the window are excluded from these rates: they were not part of the starting base. So we measure only the loyalty and revenue evolution of the initial base.

Example. If the base present 12 months ago represented €100k of MRR or ARR, and within that base over the year we observe +€15k of expansion, −€5k of contraction and −€8k of churn in value:

• NRR = (100 + 15 − 5 − 8 ) ÷ 100 = 102%
• GRR = (100 − 5 − 8 ) ÷ 100 = 87%
• Churn rate = 8 ÷ 100 = 8%

Concrete use cases

1. Stabilize a highly variable churn rate

Lets you read the real trend, rather than an abnormally high isolated month.

2. Assess growth momentum

Net MRR or ARR over 3 or 6 rolling months = a powerful indicator for your financial reviews.

3. Track seasonal trends

The Rolling Window neutralizes peaks tied to month-ends or quarter-ends.

4. Improve your renewal and cohort analyses

The sliding window lets you anticipate shifts before they show up in the calendar months.

FAQ

Does the Rolling Window replace the monthly views?
No. It complements the traditional calendar view.

Is the Rolling Window churn rate an average of the monthly rates?
No. It is calculated by cohort: churn in value of the base present at the beginning of the window, relative to that base's MRR or ARR at the start. The same goes for retention (GRR / NRR).

Is it available on all KPIs?
Almost all. Views that are already heavily aggregated (e.g. some cohort tables) are not always compatible.

Do filters and analytical dimensions work with the Rolling Window?
Yes, 100% compatible.

Does it change my exports?
No. The Rolling Window only affects the display, never the source data.

Updated on: 27/07/2026