Skip to content

Month over Month (MoM)

YAML type: mom | Category: Periodic

Compares the current month aggregate to the previous month.

Description

MoM is a common finance/ops comparison. Aggregation chooses sum vs average of daily values before comparison.

How it works

Month over Month (MoM) illustration

Month over Month aggregates daily values into the current and previous month (sum or average) and flags large percentual moves according to mode.

It is a common finance and operations check. Month length and month-end effects can inflate change -- special dates and careful thresholds help.

Setup

Set thresholds appropriate for month-length differences; consider special dates for month-end effects.

Configure detectors on the data view Analysis tab or in YAML. Validate with Data Preview before enabling production schedules.

Settings

Parameter Default Description
percentualChange 50 Minimum absolute % change
mode both Direction -- see Allowed values
aggregateMode sum Period aggregation -- see Allowed values

Allowed values

mode

Value Meaning
above Flag increases / values above the comparison (or high side of a band)
below Flag decreases / values below the comparison (or low side of a band)
both Flag either direction

aggregateMode

Used when the detector compares period totals (week / month / quarter), not raw daily points.

Value Meaning
sum Compare sums of daily values in the period (default)
average Compare averages of daily values in the period

Shared series filters

Most detectors also accept optional series filters in params:

Parameter Purpose
maxGapAmount Skip series when gap amount is too high (null = no limit). Catalog create-default is often 5.
minValue Skip series whose average value is below this (null = no limit). Catalog create-default is often 1000.
maxValue Skip series whose average value is above this (optional; omit/null = no limit)
useSpecialDates When true, suppress anomalies that overlap special dates

When a filter skips a series, Data Preview shows the reason.

Configuration example

analysis:
  detectors:
    - type: mom
      params:
        percentualChange: 50.0
        mode: both
        aggregateMode: sum

Using the detector

Widely used on Home filters for monthly KPI watchlists.

Use cases

  • Monthly P&L drivers
  • Subscription metrics
  • Cost center spend

Specifics

YoY month: mpy.