topic Challenge #2 Top 10 and Bottom 10 Products by Revenue in Incorta Conundrums

Challenge #2 Top 10 and Bottom 10 Products by Revenue

Rasha — Sun, 04 Dec 2022 22:23:24 GMT

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:

The used data files have been attached,

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

Re: Challenge #2 Top 10 and Bottom 10 Products by Revenue

Ruchita — Tue, 06 Dec 2022 04:58:14 GMT

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

Re: Challenge #2 Top 10 and Bottom 10 Products by Revenue

LukeG — Fri, 03 Feb 2023 00:08:23 GMT

Here is my solution with a demo:

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

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

Re: Challenge #2 Top 10 and Bottom 10 Products by Revenue

zhong — Mon, 27 Mar 2023 18:07:34 GMT

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

Steps:

Create Schema and tables (sales and products)
Create Join on PROD_ID within Join Editor
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).
Use Setting to limit 10 rows