What this dashboard is for
The Outlets dashboard is the within-merchant comparison view. If you run more than one outlet under the same Papaya account, this is where you see them side by side — revenue share, AOV, meal duration, channel mix, top items, and time-of-week patterns by outlet.
Open it when you want to know which of your outlets is leading on a particular metric, which is dragging, and what the differences look like over time.
How outlets are scoped
The dashboard is pinned to your merchant (your top-level Papaya account). Every chart shows every active outlet under that merchant. If your merchant has only one outlet there is not much to see here — use the Trends or Channels dashboards instead.
Many charts cap at the top 20 outlets by revenue and fold the rest into "Other" — relevant only for very large merchant groups.
The six tabs
Overall — six side-by-side comparison views (revenue share, order share, AOV, meal duration, revenue by channel, orders by channel).
Items — top 20 items across the merchant, split by outlet.
Weekly / Monthly / Yearly — same three charts (revenue, AOV, items per order) over different time scales.
Weekday — revenue and orders by hour-of-week heatmap, split by outlet.
Overall tab
1. % Revenue Share
Pie chart of revenue across outlets. Each slice is one outlet's share of the merchant's total revenue in the selected range.
How it's calculated: sum of orders.total on closed orders, grouped by outlet name. Top 19 outlets get their own slice; everything beyond falls into "Other".
2. % Order Share
The same pie but counting orders rather than revenue.
Reading it: compared with the revenue pie — an outlet with a much bigger order share than revenue share is selling more, smaller orders (often takeaway or delivery-heavy). The reverse means bigger tickets.
3. AOV
Average order value per outlet — bars side by side, highest first.
How it's calculated: revenue ÷ orders per outlet (on closed orders).
4. Median Meal Duration | Dine-in only
How long the average dine-in cheque stays open at each outlet, in minutes — measured as the time between order opening and closing. Median rather than mean so a single very long tab doesn't skew the number.
Reading it: a low number is fast turnover (counter / casual); a high number is leisurely dining. Use it as a sanity check on whether outlets are operating the way you expect.
5. Revenue | by Channel Type
Horizontal bars: revenue, segmented by channel (dine-in, takeaway, partner platforms, etc.), one bar per outlet.
6. Orders | by Channel Type
Same shape, counting orders.
Items tab
1. Quantity | Top 20 Items
The 20 best-selling items across the whole merchant, with each item's bar segmented by outlet. Useful for spotting which outlets carry which signature items and where a popular item might be underrepresented.
Weekly tab
1. Revenue | Weekly
Stacked bars: one bar per week, each segment an outlet. The merchant's total weekly revenue and how each outlet contributes.
2. AOV | Weekly
One line per outlet showing AOV over time. Drift between lines tells you whether outlets are diverging in ticket size.
3. Items per Order | Weekly
Average items on a cheque per outlet per week.
Monthly tab
1. Revenue | Monthly
2. AOV | Monthly
3. Items per Order | Monthly
Yearly tab
1. AOV | Yearly
2. Items per Order | Yearly
Note: the Yearly Revenue chart on this tab takes longer to compute than other charts; refer to the Monthly Revenue chart above for a near-equivalent view aggregated to whole years.
Weekday tab
1. Revenue | by Hour-of-Week
A 168-bucket view (7 days × 24 hours) of revenue, with each hour-of-week stacked by outlet. The labels along the bottom run Mon 00:00, Mon 01:00, …, Sun 23:00.
How it's calculated: bucketed by EXTRACT(ISODOW FROM reportingDate) and EXTRACT(HOUR FROM orderDate) in Bangkok time, summed by outlet.
Reading it: different outlets often have different weekly rhythms — an office-district outlet peaks weekday lunch; a mall outlet peaks weekend afternoons; a late-night spot fills evenings. Stack-shape differences are the giveaway.
2. Orders | by Hour-of-Week
Same shape, counting orders.
How the numbers are defined
Scope — every chart is restricted to the outlets under your merchant. The merchantId is the only top-level filter; the dashboard never asks for an outlet.
Status filter — closed orders only (
status = 'complete'). Voided / open tabs excluded.Item filter (Items tab) — confirmed items only (
order_items.status = 'confirmed').Date field —
reportingDatefor all time buckets;orderDatefor hour-of-day in the Weekday tab.Timezone — Asia/Bangkok.
Median meal duration — taken across dine-in cheques only; the difference between order open and order close, expressed in minutes; median across all cheques in the range.
Top-20 cap — pies and the items chart cap at the top 20 outlets / items by revenue; smaller outlets fold into "Other".
Filters
Reporting Date — the date range.
Merchant — pinned to your merchant when the dashboard is embedded in the Papaya portal.
Outlet / Outlet Names — optional. By default the dashboard shows every outlet; use these to narrow the comparison to a subset.
What this dashboard does NOT show
A single outlet's deep dive — use Today for live ops, Trends for historical trends, Channels / Items / Categories for breakdowns.
Multi-tier KPIs with targets and traffic-light colouring — that's the Group KPIs dashboard.
Cross-merchant industry benchmark — see Industry.
Margin / inventory / cost — see the Inventory module.

















