Analyze your metrics continuously with the Rolling Window

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

What is a Rolling Window?

A Rolling Window (or sliding window) means calculating a KPI over the last X days or the last X months, updating that window continuously.

A few possible examples:

• Average MRR over the last 3 rolling months
• Churn over the last 6 rolling months
• Net growth over the last 12 rolling months
• Cumulative revenue over the last 365 days

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

Why use Rolling Windows?

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, 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 (e.g. 3, 6, 12 months or any other value).

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

How does Fincome calculate Rolling Windows?

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

Stock KPIs → rolling average

For level indicators (MRR / ARR, number of subscribers, ARPA, LTV…), Fincome calculates the average of the values over the window.

Flow KPIs → rolling sum

For movements (recognized revenue, new MRR, 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 of the cohort present 12 months ago:

• Churn rate = churn of that cohort over the window ÷ starting MRR of the cohort.
• NRR = (starting MRR + expansions − contractions − cohort churn) ÷ starting MRR.
• GRR = (starting MRR − contractions − cohort churn) ÷ starting MRR (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, and within that base over the year we observe +€15k of expansion, −€5k of contraction and −€8k of churn:

• 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 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 of the base present at the beginning of the window, relative to that base's MRR 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 Rolling Window mode?
Yes, 100% compatible.

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

Updated on: 23/07/2026