Overview
Toolio’s New Assortment Plan includes powerful metrics—Distinct Style Count, Distinct Choice Count, and Distinct SKU Count—that help you understand and measure the breadth of your assortment. These are critical for both planning and hindsighting, enabling better decisions around how many unique products you're offering, and where.
This article covers how these metrics work, how to use them for hindsighting, and how to leverage them in reporting.
What Are Distinct Count Metrics?
Distinct Style Count: Unique style count sold (or planned to be sold) in a time period.
Distinct Choice Count: Unique style/color count sold (or planned to be sold) in a time period.
Distinct SKU Count: Unique style count sold (or planned to be sold) in a time period.
These metrics help you track assortment breadth and plan with more precision. They're also key to understanding productivity and optimizing your product offering.
How Distinct Counts Work in Toolio
Module Availability: Distinct metrics are available only in Assortment Plan module
Calculation Triggers:
Automatically recalculated when data actualizes
Can also be manually triggered using "Calculate Distinct Metrics" from the context menu.
Using Distinct Counts for Reporting
In Reports
Distinct metrics are available on reporting views, letting you analyze assortment breadth by time, channel, or store cluster.
Time Slicing
Slice your data by month, season, or custom time frames to track how your assortment breadth changes over time.
Channel/Cluster Breakdown
Filter by channel or cluster to see how many unique products are being planned or offered in each segment.
Notes
Not Available in All Modules
Distinct counts are not supported in all modules (e.g., not available in MFPBudget).
Using Distinct Counts in Derived Metrics
You can create derived metrics like CC $ Productivity = Sales / Distinct SKU Count
Example Use Cases
Hindsighting
Compare last year's Distinct Style Count to this year's plan to ensure you’re scaling your assortment as intended.
Cluster Planning
See how many unique Choices or SKUs each store cluster or channel receives—and adjust accordingly.
Productivity Analysis
See how your productivity has been evolving over time by looking at metrics like CC $ Productivity over time
FAQs
Can I break out distinct counts by full price, markdown, and promo?
Not by default, but yes—you can! While Toolio's current Distinct Count metric doesn’t explicitly break down by pricing buckets like Full Price, Markdown (MD), and
Promo, this level of granularity can be achieved with some customization.
To do this:
Use attributes: You can leverage an attribute called Launch Season (say SS25, FW25, etc.)
Group by attribute: Add this attribute as a row or column dimension in your view.
Apply Distinct Count: Once grouped, apply the Distinct Count metric to get a breakout by each launch season. You will know that if you're looking at SS25, products grouped by that Launch Season will be Full Price.
To see the attributes recommended by Toolio, please see here.