2 Replies Latest reply on Nov 30, 2016 11:56 AM by Vincent Baumel

    Sorting a bubble chart based on a secondary data source

    Vincent Baumel

      Though it pains me to say, I have to use a packed bubble chart in one of my dashboards and while I'm stuck with it, I'm trying to make it more usable. The problem is, sometimes we have 2 or 3 large values and one relatively small value - a couple giant bubbles with a tiny bubble in the middle. If all of the data were one big happy table that would be fine and I could just sort the dimension by the measure, but my dimensions are coming from a secondary data source, and the measure from a primary data source. It's not giving me a sort option! I know I could use a calculation to sort if it were a table of data (for which my continuous suggestion has so far gone unheeded), but I can't think of a way to do it dynamically with a packed bubble chart.  I can change the default sort properties of the dimension, but that's a static solution and what I'd like is a dynamic solution. Smaller bubbles would be easier to see on the outside of the pack, rather than the inside.