Ranking Bar Chart Limitation?

One way you can do this is the following:

Given this sample dataset

You can can set it the following way to have $Net Sales along the Y axis and units sold along the top. So for this example we see that Cinnamon buns sold the most units but made the least amount of money since they are cheaper than all the other items. Make sure you sort so that products sold is accounted for.

An ETL dataflow could help with this. Our goal would be to rank all the products based on some column, I assume you want Net Sales and then store that rank in a new column so that we can use it to filter on cards, so in the case of our simple bar chart we could filter where our new column we'll call SalesRank is <=5.

Do the following. New ETL

Then:

1: Add an Input Block and choose your dataset

2: Add a "Rank & Window" block

• 1: Use Rank as the type of function
• 2: Select NetSales as the column to order the function on
• 3: Descending order so highest net sales is Rank 1

3: Add an Output block and name your new dataset

Now if you go back to your card change the dataset to be the new one we created. Add the new column which contains the rank to the filter and set the filter to <= 5

I added more products to my dataset but as you can see only the top 5 show