Forum Discussion

jandrews's avatar
jandrews
Cloud Apps
02-06-2025

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!

Dashboards & Reporting

4 Replies

  • DRay's avatar
    DRay
    Admin
    02-11-2025

    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. 

  • DRay's avatar
    DRay
    Admin
    03-04-2025

    Hi GSSC & jandrews,

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

    I'm reaching out again and will respond ASAP.

  • DRay's avatar
    DRay
    Admin
    03-04-2025

    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.