Skip to main content

Using Style or CC Counts in Assortment Plan for Hindsighting and Reporting

Track and analyze your assortment breadth using Distinct Style, Choice, and SKU Counts for better planning, reporting, and hindsighting.

Updated this week

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.

Did this answer your question?