Articles on: Conducting in-depth analyses

Analyze your metrics continuously with Rolling Window

The Rolling Window offers you an alternative reading mode for your metrics: acontinuous analysis, over the last X days or X months, instead of a month-by-month segmented view. 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) consists of calculating a KPI over the last X days or the last X months, updating that window continuously.


Some possible examples:


  • Average MRR over the last 3 rolling months
  • Weighted 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 read, neutralizing seasonality and highlighting structural trends.


Why use Rolling Windows?

Smooth monthly volatility


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



The Rolling Window reveals true traction, even if your activity varies a lot month to month.


Compare trajectories on a more homogeneous basis


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


Better understand seasonality, momentum and weak signals


Ideal for anticipating trend switches.


How to use the Rolling Window in Fincome?


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


To activate it:


  1. Open the chart of your choice (MRR, growth, churn, revenue…).
  2. At the top left of the chart, click the Rolling windowbutton, located just next to the period selector.
  3. Choose the desired sliding window.


Options offered by default:


  • 3 rolling months
  • 6 rolling months
  • 12 rolling months


Custom option:


You can set your own window (e.g.: 3, 6, 12 months or any other value).


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


How does Fincome calculate Rolling Windows?


The Rolling Window mode applies one of two types of calculation, depending on the nature of the metric:


1. Moving average (for stock or ratio KPIs)


Used for:


  • MRR / ARR
  • Number of subscribers
  • ARPA
  • LTV
  • Rates (e.g.: churn)
  • Any ratio or average indicator


Fincome calculates an average over all the values in the window.


2. Rolling sum (for flow KPIs)


Used for:


  • Recognized revenue
  • New MRR
  • Contractions
  • Expansions
  • Churns (in value)
  • New customers / reactivations


Fincome adds up all values over the window.


Important example: Rolling Window for the churn rate


The churn rate in a Rolling Window is not a simple average of monthly churn rates.


Formula used:


Rolling Window churn rate = Sum of churns (in MRR) over the window ÷ Sum of MRR positions over the window


This produces a weighted average, where periods with larger MRR count more.


Important: no netting in a Rolling Window


Within the sliding window:


  • Churns, expansions and contractions are summed independently.
  • Fincome do not automatically offset (no “net” post-processing).


This choice ensures a faithful reading of the raw dynamics of the period.


Concrete use cases

📈 1. Stabilize a very variable churn rate


Allows you to read the real trend, rather than an isolated month that is abnormally high.


🧭 2. Assess growth momentum


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



The Rolling Window neutralizes spikes related to month-ends or quarter-ends.


📊 4. Improve your renewal and cohort analyses


The sliding window allows you to anticipate shifts before they appear in calendar months.


FAQ

❓ Does the Rolling Window replace monthly views?


No. It complements the traditional calendar view.


❓ Is it available for all KPIs?


Almost all. Views that are already heavily aggregated (e.g. some cohort tables) are not always compatible.


❓ Do filters and analytical axes work with Rolling Window mode?


Yes, 100% compatible.


❓ Does this change my exports?


No. The Rolling Window only affects the display, never the source data.

Updated on: 01/06/2026

Was this article helpful?

Share your feedback

Cancel

Thank you!