All lessons

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

Headline growth vs like-for-like

Same data, two honest answers: say which one you show

2024, all stores203k2025, all stores262k2025, same 4 stores232k
All stores: +29 %. The same four stores that traded in both years: +14 %. The difference is Forks Market, opened in March 2025.

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.

Try it: build a KPI card

A number on its own can't be good or bad. A KPI needs a comparison, and the colour should mean "good" or "needs attention", never decoration.

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

  1. Rideau: 2024 $42,674, 2025 $50,727, target $45,400. Work out growth and vs target.
  2. Why is month-on-month growth misleading for Northbay’s Outdoor category?
  3. Forks Market had no 2024 sales. What comparison can you use for it?
Answers
  1. Growth: 50,727 ÷ 42,674 − 1 ≈ +18.9 %. Vs target: 50,727 ÷ 45,400 − 1 ≈ +11.7 %.
  2. Outdoor rises every spring and falls every autumn, so month-on-month change mostly shows the season, not performance.
  3. 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

1Northbay grew 29 % in 2025, but opened a new store. What does like-for-like growth measure?
2Why compare a month with the same month last year instead of the month before?
3Sales beat target but fell vs last year. Which is right?

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.