Comparing a Day to Its 7-Day Rolling Average

What Is a 7-Day Rolling Average

A 7-day rolling average is calculated by averaging the net cash flow values for a 7-day window centered on (or ending at) the selected day. For example, for a day at the end of the window: it averages the net figures for that day and the 6 days before it. This rolling approach means the average moves along the timeline with you — each day has its own rolling average based on its surrounding 7-day context. Rolling averages are commonly used in financial analysis to remove day-to-day noise and reveal the underlying trend.

Finding the 7-Day Rolling Average Badge

Step 1: Navigate to the /intelligence page and scroll to the Daily Cash Chart. Step 2: Click any bar to open the Day Detail panel. Step 3: In the Day Detail panel, look for two comparison badges. The first is labelled 'vs period avg' and the second is labelled 'vs 7-day avg' or similar. Step 4: The 7-day rolling average badge shows the percentage by which this day's net cash flow differs from its own 7-day rolling average. A positive percentage means the day outperformed its local 7-day average; negative means it underperformed.

Free — no card needed

See this in action for your business

AskBiz tracks these metrics automatically — just connect your data and start asking questions.

Why Use Rolling Average Over Period Average

The period average reflects performance relative to a fixed window (7, 30, or 90 days). The rolling average reflects performance relative to the local context around that specific day. This distinction matters when your business has been improving or declining rapidly. For example, if your business was losing $500 per day last month but is now losing only $200 per day, a day with negative $200 net would look good compared to the period average (much better than the $500 average from earlier in the period) but might look neutral or even slightly poor relative to its rolling average if the 7 nearby days also averaged negative $200. The rolling average captures the immediate local trend more sensitively.

Identifying Genuine Outliers with Rolling Average

Step 1: Click a bar that appears unusually tall or short in the chart. Step 2: Check the vs-7-day-avg badge. If it shows a large positive or negative percentage (more than plus or minus 40 percent), the day was meaningfully different from its local context — a true outlier. Step 3: Look at the Channel Proxy section of Day Detail to identify which inflow or outflow category drove the deviation. Step 4: If a day is an outlier in both the period average and the rolling average badges simultaneously, it is very likely a significant event worth investigating. Step 5: If a day is an outlier in only one badge, use the context of both to understand whether it is a trend signal or a one-off anomaly.

Using Rolling Averages to Spot Trend Reversals

When reviewing the 90D chart range, click several bars at weekly intervals. If the vs-7-day-avg badge for recent days is consistently positive while the same badge for earlier days was consistently negative, this signals a trend reversal — the business has shifted from below-average to above-average performance relative to its own local context. This is one of the earliest signals available in the AskBiz chart that financial performance is improving, often visible before the metric cards show a meaningful change in the monthly averages.