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.