Retail product mix
Ten bouquets, three markets. A product mix dashboard with the photo of every bouquet next to its numbers, from the markets down to each store.
Built in Trulyp Analytics on Floraya commercial orders (demo data). Click the screenshot to open it at full size.
The thinking behind it
A product range is easy to list and hard to judge. Which bouquets pay the bills, which ones only move volume, and does every market want the same thing? This dashboard answers that for a florist with ten bouquets, five stores and three countries.
People recognise products faster than product names, so the photo of each bouquet sits next to its numbers: in the gallery, in the ranked list on the second page and in every row of the table. Every bouquet, cell and bar filters the page.
Five headline numbers: net sales, units, gross margin, average selling price and orders, all for completed orders only.
A gallery ranks the ten bouquets by net sales, with photo, flower, collection, units, margin and average price on each card.
A heatmap of units per store by flower and country shows the local favourites, and a stacked bar shows the collection mix per country.
The Product explorer lists every bouquet in every store, with its photo, and keeps a ranked photo list of the current selection next to it.
What it tells a florist
For a florist the real question is not how much was sold, but what belongs on the shelf, at what price, and where. The 2026 demo data gives four answers.
Blush Ritual brings in €451.6K at €117.76 a bouquet. Sunday Cloud sells the most units, 6,745, but at €33.42 each it earns half as much. Both matter, for different reasons.
Per store, the Netherlands sells 3,433 tulip bouquets against about 1,900 in Belgium and Luxembourg. Luxembourg sells the most roses per store, Belgium the most hydrangeas. One assortment does not fit all.
Blush Cloud is the fourth best seller at €382.1K but has the thinnest margin, 53.8%, against 68.8% for Blush Ritual. That is a pricing or sourcing conversation.
A number on the first page is one click away from the stores behind it: the Product explorer lists each bouquet per store, photo included.
Element by element
Start with the totals, meet the ten bouquets, then see how each market differs. The Product explorer takes any bouquet down to the individual store.
01
Country, channel, collection and occasion filters sit above five headline numbers. A locked filter keeps every number on completed orders, so returned and cancelled lines never inflate the totals.
02
Ten bouquets ranked by net sales, each with its photo, flower, collection, units, margin and average price. Click a bouquet and the whole page filters to it.
03
Units sold per store, by flower and country, so a market with one store compares fairly with markets that have two. Tulips peak in the Netherlands, roses in Luxembourg, and hydrangeas sell best in Belgium.
04
Each dot is a bouquet: units sold across, average selling price up, colour by collection. The premium lily sits top left, the cheap tulip far right.
05
Net sales per country split by collection, next to the channel mix. Web and mobile bring in 73% of net sales; the stores bring in a fifth.
06
The Product explorer lists every bouquet in every store with its photo, net sales bars, margin and average price. Select rows to filter the ranked photo list and the charts next to it.
Under the hood
No custom code: one data source, a locked filter and two HTML visuals do most of the work.
Pick the Floraya commercial data source. Its order lines already carry a thumbnail URL for every bouquet, which the HTML visuals and SuperTables show as images.
A locked global filter on order status keeps returned and cancelled lines out of every visual, so each chart can use plain sums.
Margin, average selling price and units per store are calculations over sums, never averages of row-level rates. Units per store lets a one-store market compare fairly with two-store markets.
SUM([quantity]) / COUNTD([store_id])Two HTML visuals use the thumbnail field: a gallery of cards on the first page and a ranked list on the second. In SuperTables, a combined column puts the photo next to the bouquet name.
Each bouquet card, heatmap cell and bar works as a filter. Pick its targets per visual, so a click on one market or bouquet narrows the whole page.
Photos, prices and margins side by side, straight from the data you already have.