Calculating Period-over-Period Changes
Use Case
Calculating period-over-period changes is essential for tracking trends and growth in key business metrics such as clicks, orders, and revenue. This guide explains how to compute period-over-period comparisons, such as week-over-week or month-over-month changes, using Reorc's semantic capabilities.
Example: Month-over-Month Change Calculation
To calculate a period-over-period metric in Reorc, follow these steps:
Step 1: Create the Base Measure
Add a new measure,
no_of_member
, and define the formula. For example, useCOUNT(DISTINCT member_id)
to count distinct members.

Step 2: Create the Compared Measure
Add another measure, for example,
no_of_member_lm
having the same formula with base measureEnable the Reporting Period feature and set the time range to Last Month.

Step 3: Calculate the Period-over-Period Change
Create a new measure that calculates the change between the current month and the last month.

Conclusion
Reorc's rolling_window feature allows for flexible and efficient calculation of period-over-period changes. By defining reporting period and calculated measures, users can easily track performance over time and derive meaningful insights from their data.
Last updated