Comparing your results from different time periods helps you put your data into perspective. For example, you might want to compare current performance to last year or measure progress from one month to the next. This article will guide you through using the time period comparison features in krunchbox reports.
Overview
Some krunchbox reports allow you to compare results using two key time periods:
- Base Period: The most recent period in your report.
- Reference Period: The previous period you are comparing it to.
Selecting a Time Period
When you open the time period drop-down filter, you will see several options:
When comparing the Selected Week versus the Previous Week:
The Selected Week is used as the Base Period.
The Previous Week becomes the Reference Period.
When comparing the Selected Month versus the Same Month Last Year.
The Selected Month serves as the Base Period.
Same Month Last Year is the Reference Period.
Using the Custom Time Period Option
If the preset options do not meet your requirements, you can choose the custom time period option:
Step 1: Open the custom time period pop-up.
` 
Step 2: Populate the Base Time Period
In the top two boxes, enter your most recent time period (Base Period)
Step 3: Populate the Reference Time Period
In the bottom two boxes, enter the time period you want to compare to (Reference Period)
Step 4: Click Save to confirm and apply your selections.
Adding Measures to Your Report
Once you have selected your time periods, you need to add the appropriate measures for both the Base Period and the Reference Period data.
Weekly Sales Units: Add weekly sales units for both the Base Period and the Reference Period in the Select Measures dropdown. In the measures, these are abbreviated as RP (Reference Period) and BP (Base Period).
Optionally, include the Weekly Sales Units Variance to see the percentage change between BP and RP.
Closing Stock on Hand: Open the stock metrics section and select closing stock on hand for both the BP and the RP. Include the Variance % metric to check if inventory levels differ from the previous period.
Running the Report
After selecting your time periods and the corresponding measures, review your selections to ensure both the base and reference periods are correctly defined, and then click Krunch to generate your report.
Once generated, your report will display sales units for:
Base Period (e.g., Selected Month) and the Reference Period (e.g., Same Month Last Year).
Variance % for both sales units and closing stock on hand, allowing you to compare performance between periods.
Watch the training video to learn more about Comparing Your Results by Time Period
If you have any questions or require further assistance, please contact us at:
support@krunchbox.com