jandrews
Cloud Apps
Joined 3 years ago
User Profile
User Widgets
Contributions
stacked column chart- show top N values, group others in "Other"
See: https://community.sisense.com/t5/build-analytics/stacked-bar-column-charts-showing-top-x-values-and-grouping-the/m-p/12598#M2005 same question as here - just reupping in case someone new can have a look. I have something like 80 values I would like to put in a stacked column but only the top 5-10 are significant at any given time - is there a way to programmatically group the rest into "Other" like Sisense does automatically in a pie chart? Note that the top 5-10 values may change over time, otherwise charting a custom column would work. ... actually, now that I'm thinking about it, I can probably put in a dynamic custom column based on percentage of the total for each column, but that is very ugly. thank you!456Views0likes4Commentsmaintaining consistent colors across charts
edit: I don't know what the label "7 - Data Storage" means or why it is there - this is about visualization. Looking for a way to ensure that colors for categories are consistent across charts, to greatly improve the user experience. For example, if I have two charts: fruit bought and fruit sold: I would like the column for "apples" to be red in both charts, the column for "oranges" to be orange in both, etc. Even if a fruit is missing from one of the charts. Obviously, I'd prefer a programmatic solution (If I add a new fruit like "kiwi" I would like it to automatically use the same color in each chart) but I suppose a manual color assignment to each category would be a start. Thanks!Solved802Views0likes5Comments