Discrete / Continuous Distribution (Planograms)

The report allows you to analyze sales indicators for each product on the planogram and identify the most and least effective positions in the layout.

In this article we will review the "Discrete / Continuous distribution" report: how to configure it and what indicators are available.

Contents

How to configure the report
How the distribution is formed
How indicators are calculated in discrete distribution
Indicators table

How to configure the report

To open the report, click "Analytics" → "Discrete / Continuous distribution" on the left toolbar.

In the "Report settings" panel:

1. Click the "Period" field and select the required date range in the calendar or use one of the ready-made options. The last 30 days are set automatically;
2. Select the indicator for analysis: Turnover, Sales quantity, Receipts quantity, Profit, Stock quantity, Stocks price, Price, Turnover per linear meter of equipment or Profit per linear meter of equipment. Turnover is set automatically;
3. Select the distribution type:
4. • Discrete — products are distributed into four groups depending on the selected indicator. Each group is highlighted in a separate color: Red: 0–10%; Blue: 10–50%; Yellow: 50–90%; Green: 90–100%. If needed, change the group boundaries in the "Distribution groups" field;
   • Continuous — products are highlighted in one color with varying intensity — the higher the indicator value, the greater the color intensity.
4. Click "Apply" to save the changes.

How the distribution is formed 

Step 1. Calculating indicators for products within the planogram
For each product on the planogram, indicators are calculated for the selected period:

• Turnover — total revenue from product sales for the selected period;
• Profit — the difference between turnover and product cost;
• Receipts quantity — the number of unique receipts mentioning the product;
• Sales quantity — the total number of product units sold during the selected period.

Step 2. Forming the planogram ranking
The planogram with the best indicator is taken as 100%. All others receive a percentage value relative to it.

How indicators are calculated in discrete distribution

The main subject of analysis is the share, which is used to evaluate various aspects of store performance.

Shares of turnover, profit, sales quantity and receipts quantity from the planogram are calculated using the following formula: y = (y1 * 100) / y2
where:
y — the share to be found (turnover, profit, sales quantity, receipts quantity);
y1 — the indicator value from which the share needs to be found;
y2 — the sum of the corresponding indicator values (y1) of all products on the planogram.

y1 — profit of "Fanta" for the selected period;
y2 — sum of profits of all products on the planogram for the selected period.

Profit share of "Fanta" from the planogram = (480 * 100) / 4338 = 11%

Indicators table

1. Product attributes:
2. • Name;
   • Article;
   • Barcode;
   • Type (packaged/weighting).
2. Indicators:
3. • Turnover — total monetary receipts from product sales for the selected period;
   • Average turnover;
   • Turnover share from planogram = (Product turnover * 100) / Sum of turnover of all products on the planogram;
   • Average turnover share from planogram = (Average product turnover * 100) / Sum of turnover of all products on the planogram;
   • Turnover per linear meter of display = Product turnover / Linear metres of product display;
   • Average turnover per linear meter of display;
   • Sales qty;
   • Average sales qty;
   • Sales qty share from planogram = (Product sales quantity * 100) / Sum of sales quantity of all products on the planogram;
   • Average sales qty share from planogram;
   • Receipts qty — excluding returns;
   • Average receipts qty;
   • Receipts qty share from planogram = (Product receipts quantity * 100) / Sum of receipts quantity of all products on the planogram;
   • Average receipts qty share from planogram;
   • Profit — the difference between turnover and product cost;
   • Average profit;
   • Profit share from planogram = (Product profit / Sum of profits of placed products on the planogram) * 100;
   • Average profit share from planogram;
   • Profit per linear meter of display = Product profit / Linear metres of product display;
   • Average profit per linear meter of display;
   • Stock qty — quantity of products in the store at the end of the selected period;
   • Stock qty share from planogram = (Product stock quantity * 100%) / Sum of stock quantity of all products on the planogram;
   • Stocks price = Product cost * Stock quantity.

The table can be flexibly configured:

• Drag columns by name to change their order;
• Hold the bottom right corner of a column and move it left or right to change its width;
• Click the arrow next to a column name to sort products by that indicator.

The following tools are available for convenient data management:

• Search — find products by name, article or barcode;
• Customize columns — select the indicators to be displayed in the table;
• Save table template — save column settings so you don't have to reconfigure the table each time.

To download the report in .xls format, click "Download report" on the top toolbar.

Updated on: 28/07/2026