Stacked Column Chart Total JavaScript

Comments

14 comments

  • Avatar
    Karoon

    Will this feature be added to the WebServers (to avoid having to write javascript)?

    0
    Comment actions Permalink
  • Avatar
    Arik

    Hi Karoon,

    Thank you for the comment.. Though this is not currently on our road map - I welcome you to post this suggestion on our feature request forum:

    https://support.sisense.com/forums/21642234-Feature-Requests

    There your post can gain traction from other users and our product designers constantly visit that page 

    to take notes and ideas for our future versions.

    Thank you again!

    Arik

    0
    Comment actions Permalink
  • Avatar
    Karoon

    How do I change the text orientation?

     

    0
    Comment actions Permalink
  • Avatar
    Sanjoy Ghosh

    This is indeed a great feature, I have used this in one of my dashboard  - but unable to increase the font size of the total. How do I increase the font size?

    0
    Comment actions Permalink
  • Avatar
    Andrew Block

    Does anyone know how to change the order of the values present in the stack?

    See attachment......I would like 0 - 12 Months to be at the bottom of the stack instead of the top is this possible?




    StackSort.PNG
    0
    Comment actions Permalink
  • Avatar
    Michael Becker

    @Andrew - have look here in the last comment - https://support.sisense.com/entries/57759194-How-To-Order-The-Break-By-Alphabetically-In-Widgets - maybe this will help you achieve what you need.

    0
    Comment actions Permalink
  • Avatar
    Andrew Block

    @Michal that does work however I lose the ability to have them sorted and the value at the top of the stack, do you know how I could merge that line of script into Inbal script so I could have the value at the top of the stack and in the order I want? 

    Thanks 

    0
    Comment actions Permalink
  • Avatar
    Michael Becker

    @Andrew - maybe try putiing code from the link at the beginning? I'm not sure if it will work though.

    0
    Comment actions Permalink
  • Avatar
    Andrew Block

    @Michal Yeah I have been trying to arrange it in different spots but can't quite get it to work. I guess I can always open a support ticket and maybe Inbal or someone from their team has a work through.

    Thanks

    0
    Comment actions Permalink
  • Avatar
    Chris Borbas

    This is great!  After sorting, is there a way to limit the number of values displayed in the widget?  The chart I am producing has 50+ columns.  I am hoping that after sorting, I can display only the top 10.  Is this possible?

    0
    Comment actions Permalink
  • Avatar
    Yoni Lerner

    Hi Chris,

     

    You can do so by creating a new value that subtotal all of the values, then create a filter on it of top 10.

    This will create a top 10 widget filter.

    After you create the filter you can eliminate this value.

    0
    Comment actions Permalink
  • Avatar
    Nick Burleigh

    Hey folks, good stuff here. I'm actually trying to implement a script that will order each break-by from largest value to smallest value within each column (NOT alphabetically or by a pre-specified order). I've been searching all over the forums to no avail on this. Has anyone successfully implemented something like this? Thanks for your help!

    0
    Comment actions Permalink
  • Avatar
    Ayanda Dube

    In a related but unrelated enquiry I have used the "Show the stack totals" script on other charts where I wasn't looking to order the columns but I needed to show the totals on stacked columns. This seems to only work in the stacked case. What if I wanted to show totals in the classic (side-by-side) case? How do I modify that?

    Thanks,

    Ayanda

    0
    Comment actions Permalink
  • Avatar
    Elliott Herz

    Here is a link to a plugin to give options to easily show bar totals, sort the categories, and sort the break bys.

    https://support.sisense.com/hc/en-us/community/posts/360020822513-Custom-Bar-Column-Chart-Plugin-Show-Totals-Sort-Categories-Sort-Breakbys-

    0
    Comment actions Permalink

Please sign in to leave a comment.