cancel
Showing results for 
Search instead for 
Did you mean: 

Challenge #2 Top 10 and Bottom 10 Products by Revenue

Rasha
Employee
Employee

In the Sales department, I need your help getting the most sold products and the least sold products

It should be in 2 insights like these:

Screen Shot 2022-12-05 at 12.14.55 AM.png

Screen Shot 2022-12-05 at 12.15.13 AM.png

The used data files have been attached,

It is very simple, When you try it you will find it is fun 🙂

3 REPLIES 3

Ruchita
Cosmonaut

You can sort the data
- For Top 10 - into descending order by Revenue,
- For Bottom 10 - into ascending order by Revenue,
and then go to settings and apply Max rows constraint to 10

LukeG
Employee
Employee

Here is my solution with a demo:

  1. Create schema and join on product id
  2. Create business schema with necessary fields (optional)
  3. Group data by product name and aggregate amount sold
  4. Sort by amount sold
  5. Limit rows to 10

https://www.youtube.com/watch?v=3cOzDDF4Lwg

zhong
Partner
Partner

 

zhong_0-1679940342206.png

 

zhong_1-1679940354090.png

 

We need to join the Sales and Products table first. The easiest way is to use Incorta JOIN Editor tool. 

Steps: 

  1. Create Schema and tables (sales and products)
  2. Create Join on PROD_ID within Join Editor
  3. Use Incorta Analyzer to create the two insights. Drag PRUD_NAME to grouping dimension and AMOUNT_SOLD TO measure. Add AMOUNT_SOLD to PRUD_NAME’s Property setting Order By (ASC for Bottom 10, DESC for Top 10).
  4. Use Setting to limit 10 rows