I am trying to illustrate ranges of values group by fields within a visual.
As an example, I have salespeople who sell various products at various prices. I want to then illustrate the range of prices each sales person sold each product at. The visual would look something like:
I have tried using pivot tables, where I create columns for pricing (eg $50-55, $55-60, etc) but then if the sales person only sold a product at $52 and $75, then all the intermediate columns would be blank. Alternatively, I could use a horizontal bar chart, but then I can’t show the groupings of Sales Person and Product on the axis along with count of sales.
@ErikG Good idea, but unfortunately it won’t work here. Each of the groups have values (sale prices) that are independent of each other. They don’t sum up together into anything meaningful.
I’m playing around with box plots right now. There might be something there for me to work with.
Hello @JMthinkrf, were you able to find your expected solution by utilizing box plots or a different visual type? I wanted to check in and make sure you solved the problem you were facing. If not, please let me know what you have done so far and we can figure out a different solution. Thank you!
Hello @JMthinkrf, maybe you could have some luck with using a filter action and display the data across 2 visuals to get closer to your desired solution. You could do a stacked bar chart that would show the products, number of each product sold, and then you could use the salesperson as the Group/Color field.
Then you can set up an action to filter another bar chart visual by the Product selected, where you can show the price groupings as the x-axis (it would have to be returned as a string value), count of products sold, and then group/color can be salesperson. You could even include a single select dropdown with your product options. Or you could have the 2nd visual filtered by salesperson, keep groupings as x, count of sales as y, and then your group/color field could be for Product.
I think you will have more luck getting closer to your expected visual representation by splitting this up into 2 visuals that the user could interact with. I will mark this as a solution for now, but if you have more questions please let me know. Good luck!
