Module 4: KPI design · Lesson 4.2 · about 13 min
Compared to what? Targets, last year and like-for-like
A number alone is neither good nor bad. How to compare against target, last year, the average or like-for-like stores, and how the choice changes the story. Northbay's 29 % growth becomes 14 % like-for-like.
Module 4 · about 13 minutes · read first: 4.1. You’ll be able to choose the right comparison for a KPI, and see how it changes the story.
1. Why this matters
“Sales were $262k.” Good or bad? You can’t tell without a comparison. The comparison you pick can make the same number look like success or failure, so choosing it honestly, and saying which one you used, is central to data storytelling.
2. The idea in one picture
Same data, two honest answers: say which one you show
Both numbers are true. “Up 29 %” answers “is the business bigger?”; “up 14 %” answers “are our stores doing better?”.
3. The common comparisons
| Compare with | Answers | Watch out for |
|---|---|---|
| Target / budget | Are we on plan? | Targets can be set too low or too high |
| Same period last year | Are we growing? Removes seasonality | Last year may have been unusual |
| Previous period (last month) | Is it getting better right now? | Seasonality: December always beats November |
| Like-for-like (same stores) | Is underlying performance improving? | Define which stores count, and stick to it |
| Average / other units | How does this store compare? | Different sizes: compare rates, not totals |
| Year to date | Is the year on track? | Early in the year, small numbers swing a lot |
Maths and principle
Growth = (this period − comparison) ÷ comparison. All stores: (262,470 − 203,438) ÷ 203,438 ≈ +29 %. Like-for-like (the 4 stores open in both years): 2025 = 78,295 + 57,838 + 50,727 + 45,433 = 232,293; (232,293 − 203,438) ÷ 203,438 ≈ +14 %. Vs target = actual ÷ target − 1: 262,470 ÷ 246,300 − 1 ≈ +6.6 %.
Principle: a comparison is a choice of question. State it in the label (“vs same month last year”, “like-for-like”) so the reader knows which question was answered.
4. Try it
Set the measure to Sales and the period to 2025, full year, then compare with Last year. Read the note under the card. Then try February 2025 with Target and last year.
5. Worked example
December 2025 sales: $30,031.
- vs November 2025 ($27,025): +11 %. But December is always the peak.
- vs December 2024 ($22,313): +35 %. Includes Forks Market.
- vs target ($27,000): +11 %.
The honest headline for a sales review: “December beat target by 11 % and last December by 35 % (including the new store).”
6. Practice
- Rideau: 2024 $42,674, 2025 $50,727, target $45,400. Work out growth and vs target.
- Why is month-on-month growth misleading for Northbay’s Outdoor category?
- Forks Market had no 2024 sales. What comparison can you use for it?
Answers
- Growth: 50,727 ÷ 42,674 − 1 ≈ +18.9 %. Vs target: 50,727 ÷ 45,400 − 1 ≈ +11.7 %.
- Outdoor rises every spring and falls every autumn, so month-on-month change mostly shows the season, not performance.
- Its target (99.6 % achieved), other stores’ first years, or its share of chain sales.
Next, Lesson 4.3: designing the KPI card itself.
Check yourself
Your ticks stay in this browser. Save them as a file on the course home.
Updated 2026-11-22. Northbay Goods is a made-up shop and its numbers are generated. The writing checks are simple rules run in your browser; nothing you type is sent anywhere or kept.