Liquid & Larder — Dashboard Consistency Review

The headline

What's actually wrong

The current-year numbers hold up across users; the real defect is in the weekly year-on-year comparison behind your two screenshots.

The real bug — weekly "Total Rev last year". On This Week and Last Week, the last-year comparison figure does not reliably reflect the venue on screen. Because last-year numbers are historical, they don't drift — so every difference below is real and reproducible.

Exhibit A · your screenshots, reproduced

Alexandre vs Shaun — same week, same venue

Alexandre is locked to Alfie's. Shaun pinned to Alfie's. Every current-year number matches to the cent — only the last-year figure diverges, exactly as in the screenshots.

Alexandre CamilieriVenue Manager · Alfie's (locked, no selector)

Actual Revenue$78,098.00

Actual Covers807

Forecast Revenue$95,964.00

Target Revenue$105,560.40

Total Rev last year$650,725.04

LY Spend per head$138.60

Shaun LauHead of Quality · venue selector set to Alfie's

Actual Revenue$78,098.00

Actual Covers807

Forecast Revenue$95,964.00

Target Revenue$105,560.40

Total Rev last year$129,131.53

LY Spend per head$112.33

Why $650,725.04? It's the all-venues last-year total — we confirmed it by setting the venue selector to blank, which returns the exact same $650,725.04 / $138.60. So Alexandre's current revenue is correctly filtered to Alfie's, but his weekly last-year figure quietly falls back to the whole group. Shaun's $129,131.53 is the correct Alfie's value.

Exhibit B · the smoking gun

The same week's "last year" by venue

If the metric were correctly venue-filtered, each venue would have one value and all-venues would be the sum. Neither holds. One venue shows two values; two different venues show the same value.

User / context	Venue shown	Total Rev last yr	LY Spend/head	Assessment
Pip Pratt (all venues)	— (all)	$650,725.04	$138.60	Baseline: all-venues total
Shaun @ all venues	— (all)	$650,725.04	$138.60	Matches baseline
Alexandre (locked)	Alfie's	$650,725.04	$138.60	WRONG — shows all-venues, not Alfie's
Shaun @ Alfie's	Alfie's	$129,131.53	$112.33	Correct Alfie's value
Jimmy @ Alfie's	Alfie's	$129,131.53	$112.33	Matches Shaun
Kim @ Bistecca	Bistecca	$189,068.24	$182.25	Bistecca-specific
Georgio @ Bar Julius	Bar Julius	$47,081.51	$54.57	WRONG — identical to Rover ↓
Douglas (locked)	The Rover	$47,081.51	$54.57	Same as Bar Julius — different venue!
Shaun @ The Rover	The Rover	$27,684.05	—	Different from Douglas's Rover

For Alfie's, two users disagree ($650,725.04 vs $129,131.53). For Bar Julius vs The Rover — two different venues — two users agree ($47,081.51). Both are impossible if the figure were correctly venue-filtered. The weekly year-on-year number simply isn't trustworthy. Monthly, quarterly and YTD last-year figures, by contrast, agree across every user.

Full sweep

All nine periods, three users

Alexandre (Alfie's, locked) vs Shaun pinned to Alfie's is the like-for-like pair; Douglas (Rover, locked) is shown for contrast. Highlighted cells are the only ones that diverge between the matched pair.

Metric	This Week	Last Week	This Month	Last Month	This Qtr	Last Qtr	YTD
ALEXANDRE — Alfie's (locked)
Actual Revenue	$78,098	$127,021	$205,119	$660,621	$1,447,048	$1,775,138	$7,093,484
Actual Covers	807	1,089	1,896	5,753	12,670	16,766	64,096
Total Rev last yr	$650,725	$760,516	$590,774	$694,888	$1,845,417	$1,726,603	n/a
SHAUN — Alfie's (selector)
Actual Revenue	$78,098*	$127,021	$205,119	$660,621	$1,447,048	$1,775,138	$7,093,484
Actual Covers	807	1,089	1,896	5,753	12,670	16,766	64,096
Total Rev last yr	$129,132	$142,550	$590,774	$694,888	$1,845,417	$1,726,603	n/a
DOUGLAS — The Rover (locked)
Actual Revenue	$12,344	$35,646	$47,990	$162,497	$353,889	$456,799	$1,678,963
Actual Covers	251	708	959	3,438	4,764	0	4,764
Total Rev last yr	$47,082	$44,612	$133,368	$166,664	$429,179	$454,167	n/a

* Shaun's This Week actual was read ~25 min earlier; a back-to-back re-read matched ($96,811.43). Only the highlighted weekly last-year cells diverge between the matched pair. The Rover shows Forecast Covers = 0 every period (a separate data-entry gap), and Last Quarter covers read 0.

Also worth knowing

Two smaller inconsistencies

Each person opens on a different venue

The venue choice is stored per user, so the dashboard opens on whatever they last had: Shaun & Jimmy → Alfie's, Kim → Bistecca, Georgio → Bar Julius, Pip → all. The "Weeks" picker default also varies (Alexandre Wk14, Shaun Wk05, Douglas none). Worth standardising the default so everyone starts from the same place.

The Rover has no forecast covers

For The Rover, Forecast Covers reads 0 in every period, which makes its Cover Difference meaningless (it just echoes actual covers). Looks like missing forecast data for that venue rather than a dashboard fault — but it makes Rover's covers variance unusable.

For the build · confirmed in the data

Root cause — found it in the Performance table

The Performance table is a single row that recomputes per signed-in user. We traced the displayed weekly figure back to its query and read the conditions directly.

The trace. Display "Total Rev last year" (This Week) ← Rollup "Week View / EOD Total last year" (Sum) ← query "Week View / Q Cashup Week a Year Ago" → EOD Total Revenue. That query (source: the Cash up table) filters on Year = last year, Week number = this week, and Venue includes [ This row → Venue ].

Wrong venue column

The weekly query filters on "Venue" — the raw venue-selector value — instead of "Venue to use", the resolved venue that every correct metric on the page uses.

Locked users have a blank selector

For Alexandre the Performance row reads Venue = blank, User Venue = Alfie's, Venue to use = Alfie's. "Venue includes blank" matches every venue — we watched the query return Gidley, Rover and the rest — so the rollup becomes the all-venues total ($650,725.04).

It only "works" by luck

For users whose selector is set (Kim → Bistecca), "Venue" happens to equal "Venue to use", so the figure looks right. The monthly/quarterly columns are consistent because they already key off the resolved venue.

The fix (and a couple of extras)

Point the weekly queries at "Venue to use", not "Venue". In "Q Cashup Week a Year Ago" (This Week) and its Last Week twin, change the Venue condition from [This row → Venue] to [This row → Venue to use]. That matches the current-year and monthly/quarterly logic and fixes every locked user at once.
Audit the other "Week View" last-year columns (LY Spend per head, daypart breakdowns) for the same Venue-vs-Venue to use mistake while you're in there.
Standardise the stored venue default and the "Weeks" picker default so everyone opens on the same starting state.
Add forecast covers for The Rover (or hide its Cover Difference) so the variance isn't misleading.
Sanity-check the headline rollup: in spots "Actual Revenue" exceeded the sum of its own Cash + EFTPOS + Vouchers detail — worth confirming the components reconcile.