Dashboard

Sample dashboard · synthetic data

Sample store dashboard

Synthetic data for a fictional outdoor-gear retailer with 18 stores, January to September 2026. Every order, from any channel, is fulfilled by one store.

Revenue, year to date

Definitions

Revenue
revenue, version 2. Confirmed on Oct 1, 2026
Order value in euros after discounts, excluding cancelled and refunded orders.
Expression, filter and grain of revenue
Expression
sum(net_amount_eur)
Filter
order_status not in ('cancelled', 'refunded')
Grain
one row per order line
Data
Data for Revenue, year to date
MonthRevenue
Jan 2026€355K
Feb 2026€377.4K
Mar 2026€395.7K
Apr 2026€406.5K
May 2026€409.1K
Jun 2026€406K
Jul 2026€402.3K
Aug 2026€403.6K
Sep 2026€414.1K

Orders, year to date

Definitions

Orders
orders, version 1. Not confirmed
Orders placed in any channel, each counted once, excluding cancelled orders.
Expression, filter and grain of orders
Expression
count(distinct order_id)
Filter
order_status <> 'cancelled'
Grain
one row per order
Data
Data for Orders, year to date
MonthOrders
Jan 20266,074
Feb 20266,455
Mar 20266,768
Apr 20266,953
May 20266,996
Jun 20266,943
Jul 20266,878
Aug 20266,900
Sep 20267,079

Stores reporting

Data
Data for Stores reporting
StoreStores
S011
S021
S031
S041
S051
S061
S071
S081
S091
S101
S111
S121
S131
S141
S151
S161
S171
S181

Monthly revenue by region

Definitions

Revenue
revenue, version 2. Confirmed on Oct 1, 2026
Order value in euros after discounts, excluding cancelled and refunded orders.
Expression, filter and grain of revenue
Expression
sum(net_amount_eur)
Filter
order_status not in ('cancelled', 'refunded')
Grain
one row per order line
Month
order_month, version 1. Confirmed on Oct 1, 2026
The calendar month in which the order was placed, in the local time of the store that fulfils it.
Expression and grain of order_month
Expression
order_date
Grain
month
region
region, version 1. Not confirmed
The sales region of the store that fulfils the order: North, South or West.
Expression of region
Expression
store_region
Data
Data for Monthly revenue by region
MonthRegionRevenue
Jan 2026North€118,000
Jan 2026South€96,000
Jan 2026West€141,000
Feb 2026North€125,930
Feb 2026South€101,560
Feb 2026West€149,890
Mar 2026North€132,570
Mar 2026South€105,980
Mar 2026West€157,180
Apr 2026North€136,720
Apr 2026South€108,340
Apr 2026West€161,480
May 2026North€138,110
May 2026South€108,490
May 2026West€162,490
Jun 2026North€137,600
Jun 2026South€107,140
Jun 2026West€161,250
Jul 2026North€136,860
Jul 2026South€105,640
Jul 2026West€159,770
Aug 2026North€137,840
Aug 2026South€105,470
Aug 2026West€160,290
Sep 2026North€141,980
Sep 2026South€107,680
Sep 2026West€164,460

Orders by region

Definitions

Orders
orders, version 1. Not confirmed
Orders placed in any channel, each counted once, excluding cancelled orders.
Expression, filter and grain of orders
Expression
count(distinct order_id)
Filter
order_status <> 'cancelled'
Grain
one row per order
Month
order_month, version 1. Confirmed on Oct 1, 2026
The calendar month in which the order was placed, in the local time of the store that fulfils it.
Expression and grain of order_month
Expression
order_date
Grain
month
region
region, version 1. Not confirmed
The sales region of the store that fulfils the order: North, South or West.
Expression of region
Expression
store_region
Data
Data for Orders by region
MonthRegionOrders
Jan 2026North2,021
Jan 2026South1,749
Jan 2026West2,304
Feb 2026North2,156
Feb 2026South1,850
Feb 2026West2,449
Mar 2026North2,270
Mar 2026South1,930
Mar 2026West2,568
Apr 2026North2,341
Apr 2026South1,973
Apr 2026West2,639
May 2026North2,365
May 2026South1,976
May 2026West2,655
Jun 2026North2,356
Jun 2026South1,952
Jun 2026West2,635
Jul 2026North2,343
Jul 2026South1,924
Jul 2026West2,611
Aug 2026North2,360
Aug 2026South1,921
Aug 2026West2,619
Sep 2026North2,431
Sep 2026South1,961
Sep 2026West2,687

Revenue by region, year to date

Definitions

Revenue
revenue, version 2. Confirmed on Oct 1, 2026
Order value in euros after discounts, excluding cancelled and refunded orders.
Expression, filter and grain of revenue
Expression
sum(net_amount_eur)
Filter
order_status not in ('cancelled', 'refunded')
Grain
one row per order line
Region
region, version 1. Not confirmed
The sales region of the store that fulfils the order: North, South or West.
Expression of region
Expression
store_region
Data
Data for Revenue by region, year to date
RegionRevenue
North€1,205,610
South€946,300
West€1,417,810

Orders by channel, year to date

Definitions

Orders
orders, version 1. Not confirmed
Orders placed in any channel, each counted once, excluding cancelled orders.
Expression, filter and grain of orders
Expression
count(distinct order_id)
Filter
order_status <> 'cancelled'
Grain
one row per order
channel
channel, version 1. Confirmed on Oct 1, 2026
Where the customer placed the order: web, mobile app, marketplace or store pickup.
Expression of channel
Expression
order_channel
Data
Data for Orders by channel, year to date
ChannelOrders
Web26,202
Mobile app19,144
Marketplace10,418
Store pickup5,282

Orders and average basket by store, year to date

Data
Data for Orders and average basket by store, year to date
Orders, year to dateFormatAverage basket
5,093Flagship€63.56
3,508Standard€48.02
1,984Outlet€39.05
4,288Flagship€71.88
2,438Standard€54.56
1,496Outlet€35.40
5,396Flagship€79.33
2,590Standard€50.75
2,079Outlet€46.77
5,856Flagship€69.30
4,073Standard€47.55
2,319Outlet€38.04
4,550Flagship€62.79
2,910Standard€61.50
1,612Outlet€41.91
6,042Flagship€68.73
3,326Standard€47.84
1,486Outlet€36.93

Top products, year to date

Top products, year to date
ProductCategoryUnitsRevenue (EUR)
Trail running shoeFootwear3,120389,880
Rain shell jacketApparel2,210309,400
Merino base layerApparel4,050243,000
Insulated bottleAccessories6,900172,500
Day pack 24LBags1,980158,400
HeadlampAccessories3,650127,750
Hiking sock 3-packApparel7,120113,920
Trekking polesAccessories1,24099,200

Definitions

Revenue (EUR)
revenue, version 2. Confirmed on Oct 1, 2026
Order value in euros after discounts, excluding cancelled and refunded orders.
Expression, filter and grain of revenue
Expression
sum(net_amount_eur)
Filter
order_status not in ('cancelled', 'refunded')
Grain
one row per order line

Dashboard details

Charts
9
Datasets
4
Rows
57
Chart format
chart.v1
Data
Synthetic

About this sample

Every figure here is synthetic. A shared dashboard opens on this page the same way: charts drawn in your browser from the snapshot that was published.

Emolysis builds dashboards like this one from a question: a tested gold table and its charts. Publishing them as links is part of the paid plans.

How dashboards work