# Analyze your metrics continuously with the Rolling Window

The Rolling Window offers you an alternative reading mode for your metrics: a**continuous 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**

{% hint style="info" %}
The goal: **a smoother read**, neutralizing seasonality and highlighting structural trends.
{% endhint %}

## **Why use Rolling Windows?**

### Smooth monthly volatility

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

### See trends more clearly

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 window**button, 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.

{% hint style="warning" %}

### **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.
{% endhint %}

{% hint style="danger" %}

### **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.
{% endhint %}

## **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.

#### 🔍 3. Track seasonal trends

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.
