Articles on: View store plans

Discrete / Continuous Distribution (Store plans)

The report allows you to evaluate the effectiveness of planograms on the store plan and identify the best-performing and least effective shelving units on the store plan.


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
General indicators used in analytics
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 qty, Receipts qty, Profit, Stock qty, Stocks price, Turnover per linear m of equipment or Profit per linear m of equipment. Turnover is set automatically;
  3. Select the distribution type:
    • 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. This data serves as the basis for further analysis:

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


Step 2. Aggregating indicators for the planogram

For each planogram, aggregate values are calculated across all products: the sum of turnover, the sum of profit, and the total number of receipts and sales


Step 3. Forming the planogram ranking

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


For example! If planogram "1" has a turnover of 10,000 $ (100%), and planogram "2" has 8,000 $, its rating will be 80%.


Important! Product sales are not linked to a specific shelving unit. Therefore, if one product is placed on several planograms and was sold during the specified period, its sales are counted in all planograms where it is present. For example: Coca-Cola is placed on three planograms, and 5 units were sold during the period. These 5 sales are recorded simultaneously in all three planograms.



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, receipts quantity and stock are calculated using the following formula:


n = (n1 * 100) / n2


where:
n — the share to be found (turnover, profit, sales quantity, etc.);
n1 — the indicator value from which the share needs to be found;
n2 — the sum of the corresponding indicator values (n1) of all equipment on the store plan.



For example! Let's determine the Turnover share of the "Fanta" shelving unit from the store:


n1 — turnover of the "Fanta" shelving unit for the selected period;
n2 — total turnover of all shelving units in the store for the selected period.


Turnover share of the "Fanta" shelving unit from the store = (7,014.60 * 100) / 65,480.75 = 11% 


Important! The result is rounded to two decimal places.



General indicators used in analytics


Note! Data from receipts marked as is_excluded = 1 is not included in the calculations. Indicators are calculated based only on regular sales, excluding return receipts.


  • Turnover — the sum of monetary receipts from sales for the selected period;
  • Profit — the difference between turnover and product cost;
  • Sales qty — the total number of product units sold during the selected period;
  • Receipts qty — the total number of sales receipts for the selected period, excluding return receipts;
  • Stock qty — the quantity of products in the store and/or warehouse at the end of the last day of the selected period.



Indicators table

At the bottom of the page, a table with data for the selected period is displayed: 

  1. Planogram attributes:
    • Planogram name;
    • Planogram type (Basic/Additional).
  2. Indicators:
    • Turnover;
    • Turnover share from store, % = (Turnover of products on the planogram * 100) / Sum of turnover of all planograms on the plan;
    • Turnover per linear m of equipment = Turnover of products on the planogram / Linear metres of equipment;
    • Sales qty;
    • Sales qty share from store, % = (Sales quantity of products on the planogram * 100) / Sum of sales quantity of all planograms on the plan;
    • Receipts qty;
    • Receipts qty share from store, % = (Quantity of unique product entries in receipts on the planogram * 100) / Sum of receipts quantity of all planograms on the plan;
    • Profit;
    • Profit share from store = (Profit of products on the planogram * 100) / Sum of profit of all planograms on the plan;
    • Profit per linear m of equipment = Profit of products on the planogram / Linear metres of equipment;
    • Stock qty;
    • Stock qty share from store, % = (Stock quantity of products on the planogram * 100) / Total stock quantity of products of all planograms on the plan;
    • Stocks price = Product cost * Stock quantity of this product.


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


Important! The downloaded file is generated taking into account the applied column display settings and search filters.

Updated on: 05/08/2026

Was this article helpful?

Share your feedback

Cancel

Thank you!