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!

jandrews

Posted 1 year ago·Last reply 1 year ago

4 comments

DRay

·1 year ago

Hi GSSC & jandrews ,

If you're okay without the "group the rest as other" part then it can be done by using a widget filter (rank top 5 on whatever Value you're applying the break-by on), but otherwise it will require either pre-aggregation at the data model level (We can connect you to a resource to consult on how this can be done) or a custom plugin (which would have to go to a Partner for a paid engagement).
Either way, I think this would be a great feature request. Can you post this in the Product Feedback Forum?

Can you let me know if you want me to get the ball rolling on connecting you with a technical resource?

Thank you.

DRay

·1 year ago

Hi GSSC & jandrews,

Sorry for the delay on this. Thank you for following up.

I'm reaching out again and will respond ASAP.

GSSC

·1 year ago

Any update on this internally DRay?

DRay

·1 year ago

Hello jandrews,

Thank you for reaching out. I see your question hasn't gotten a response yet, so I'm asking internally to try and get you an answer.