4 Replies Latest reply: Dec 22, 2016 4:41 PM by Cynthia McLauchlan RSS

    Bar chart legend showing more than limited dimension values

    Cynthia McLauchlan

      I've used the option to restrict the number of dimension values shown in a bar chart to be the top 10. However, the legend still depicts all values, resulting in a very long and confusing legend. Since there are a lot of colour overlaps, it's also very difficult to find what the 10 values displayed in the bar chart correspond to.

       

      I would like to have my bar chart show the Top 10 dimension values based on my measure (currently doing so), and then have the legend only show these top 10 dimension values.

       

      Amendment: when using two dimensions (say date and medium), limiting the second dimension appears to result in a Top 10 medium for EACH date. The question is therefore how to limit medium to the Top 10 overall, without aggregating by the first dimension.