1 Reply Latest reply: Nov 1, 2012 4:07 AM by Jonathan Brough RSS

    Stacked Bars limted display to top 5 + Other

      Please help with this business question stacked bar charts. 

       

      The requirement is to display only 6 items in a stacked bar; however the underlying data has about 26 variables.  In the display the first 1-5 blocks will be those with the highest count value.  Number 6 displayed as “other” will include an aggregation of all other values. 

       

      In the use case if a user should select the 6th value this would only display 6 more blocks in the bar identifying the second group of 5 by name and the 6th as “Other”.

       

      If the users should select on the initial chart lassoing item 5 and 6 then number five would be the largest of the values.