Ranking Bar Chart Limitation?
Hi -
I've built a simple bar chart that shows the top 5 selling products ranked by net sales. I have the series set to the Product Category they belong to. I've been asked to add the quantity (# of units sold) measure. I'm not finding a way to add in another measure. Any suggestions?
Thanks,
P -
Comments
-
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.
**Make sure to like any users posts that helped you and accept the ones who solved your issue.**1 -
Thanks, this gets me most of the way there. However, I lose the ability to limit the result to just 5 bars once I put in the #Units Sold. Any thoughts on this?
Ignoring Maximum Bars setting
0 -
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
**Make sure to like any users posts that helped you and accept the ones who solved your issue.**0 -
Thanks for the suggestion but this did not work. My card is part of a dashboard with several other cards. I'm using a Sales Date page filter so the product ranking will change dependent upon date range.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive