Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a bubble chart showing the count of times a product was ordered on the X-axis, the count of unique customers that purchased the product on the Y-axis, and the sum of the order quantity on the Z-Axis (bubble size).
Now I want to limit the data displayed to the top 10 values by quantity ordered (Z-Axis or 3rd Expression), but the Dimension Limits tab only uses the first expression (X-axis ~ count of times ordered).
How can I reduce the data displayed based on the quantity ordered?
Scott,
Try to replace your dimension, whatever it is, with a calculated dimension where you use rank function, i.e. where rank(<your 3rd expression>) <=10.
Regards,
Michael