Skip to main content

Top 10 Products by Sell Through Percentage

Learn How to Rank your Top 10 Products by Sell Through Percentage as a Power User in Performance Analytics

Luke Albrecht avatar
Written by Luke Albrecht
Updated yesterday

In Performance Analytics, Power Users can create a custom metric to rank their top 10 products by sell through percentage.

This custom metric identifies products with high sell-through percentages (ST%) to quickly pinpoint items needing extra attention for maintaining adequate stock levels and supporting strong sales. This metric will also exclude any products with 100% Sell-through, as these items are often no longer being sold.

💡Don't know if you are a Power User? Determine your user status here.

This metric will work with any report or dashboard with a data grid, but is designed to help you analyze data at the product level. The below example uses the pre-made Product Performance dashboard, but you can use any pre-made or custom dashboard that includes the ST% metric.


Click on images to enlarge.

Step

Instruction

Image

1

Open any dashboard or report.

Example:

  1. Navigate to the: Dashboards folder.

  2. Fundamental Dashboards folder.

  3. Select the Product Performance dashboard.

2

Right-click on the ST% metric (in this example, TY WTD ST%) and select Create Metric.

3

Click on Switch to Formula Editor at the bottom right hand side of the Metric Editor.

Delete the default formula, copy the following and paste into the Formula box:

IF(([TY WTD ST%]>=1), " ", [TY WTD ST%])

4

Enter ST% Calc as the Metric Name and click Save

5

Right-click on the new metric ST% Calc and hover over Shortcut Metric and click Rank or OK (there's no need to adjust the Sort or Break settings).

6

Click on the table's three-dot menu icon and Edit Filter.

Then, click Add New Qualification and enter Rank (ST% Calc) into the Based On field. Change the Operator to Less than or equal to and enter 10 as the value. Then click OK and Save.

7

Right-click on the Rank (ST% Calc) metric and Sort Ascending to view products in order by ST%.


⛑️ SPS Analytics Support

If you have any additional questions regarding editing metrics, attributes, or Performance Analytics, please reach out to our Analytics Support team at the contact information below:

☎️ 888-739-3232, Option 2

Did this answer your question?