Stock Evolution

Visualize and analyze the evolution of stocks and their distribution

Written by OpenHealth - Customer Success Center
Updated over a week ago

View and analyze stock indicators over adjacent monthly periods.

Module name

Trigram: SKE



The Stock Evolution sheet allows you to analyze the last 36 months:

  • The evolution of stocks volumes on the market and retail by segment, laboratory, brand and product

  • The number of stockist pharmacies, stockist digital distribution and stockist value distribution

  • The performance of stockist pharmacies, thanks to DNV / DNS and DVV / DVS ratios

This module is for you if:

  • Stock is a key indicator in your trading performance

  • Your activity is seasonal and stock has an impact on sales

  • You or your competitors are leading an active drugstore storage strategy

Data sources

Geographic territories

  • Metropolitan France data


  • No limitation on the size of the markets

  • Applicable to human medicinal products, veterinary medicinal products and non-medicinal products



Sales & Marketing Advanced

Objects found in the sheet

  • Functional cartridge

  • Time buttons

  • Indicator buttons

  • Object 'Stock Distribution'

  • Object 'Stock Evolution (volume)'

  • Object 'Stock Comparison (volume)'

  • 'Transformation Rate Stock' object

Indicators & measures

  • Stock Volume

  • Number of stockist pharmacies

  • Stockist Value Distribution

  • Stockist Volume Distribution

  • DNV / DNS ratio

  • DVV / DVS ratio


  • Qualifying Fields Product Fields (CQCP) in MyQuery


Current version:

  • Enhancement of the bar-graph according to the grid and replacement of the drop-down selector.

Old versions:

  • Addition of the "Data Input" Warning within the traceability cartridge

  • Changed the size of the Grid and the placement of objects closer to the original and added the DOE (Internal Technical Improvement) cartridge

  • Addition to the Line Chart at the top left of the N Monthly Rebased NDStock indicators and the Rebased ND Sales / Rebased ND Stock ratio indicator.

  • Module recipe version v2004271727 standard , no change compared to version v2004070930 of this module.

  • The WD Sales / WD Stock indicator is not currently available in this module version.

  • Removal of the "PHARMA ONLY" mention just below the market to group the traceability dates together.

  • Added labels to the "Transformation Rate Stock" scatter plot as well as to the "Stock Comparison (Volume)"

  • Variability of the subscription within the cartridge.


  • Changed the time dimension of all charts from Period_MonthName to Period_MonthName_formatted

  • Complete variability of all graphic labels (dimensions, measures)

Evolution> p 0Y000001Iu7o #

  • Modification of the previous automation of the market qualifying hierarchical field selector for more speed when updating the App. (dynamic value) (Internal Technical Improvement).

  • Modification of the display modalities selector with addition of hierarchical fields qualifying the market, automatically.

  • Fix for "Success" link

  • The indicators are pre-calculated in the App modeling stage. This sheet can only be displayed in version vF51 of the flow. (Internal Technical Improvement)

  • Internal Technical Improvement

  • Implementation of the link to "Success"

Did this answer your question?