Draw Total Line for a Stacked Column or Bar Chart

Comments

7 comments

  • 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
  • Avatar
    Teh Wenhui

    Hi Elliott,

    The plugin is helpful to show the total value compared to putting the previous long javascript.

    Can I choose which items to include in the total value instead of including all items by default?

    0
    Comment actions Permalink
  • Avatar
    Elliott Herz

    Hi Teh Wenhui,

    Nope, you cannot choose what series are added to the total, it is assumed that every series will be added to the total. If you have very specific requirements like this, then I'd recommend a widget script instead of the plugin.

    Best, Elliott

    0
    Comment actions Permalink
  • Avatar
    Christina Carr

    Hi!  Is it possible to send the same widget script but for a line chart as well?  I tried to implement this on a line chart but since the chart type is different it did not work.

     

    Thank you!

    Tina

    0
    Comment actions Permalink
  • Avatar
    Jessica Orlando

    Is it possible to do this visual but instead of the line being the total, the line is a 3rd metric? So metric A and metric B are a stacked bar and metric C is a line?

     

    Thanks!

    0
    Comment actions Permalink
  • Avatar
    Max Reich

    Hi Jessica, 

    You can accomplish this task by taking the following steps: 

    1. Add Metric A and Metric B to the Values of your column / bar chart per usual. Confirm there is a category included to act as our X axis (Y axis in the case of a bar chart). 

    2. Toggle over to the "Design" pane of the widget on the top right hand side of the editor, next to the Filters pane. Select Column Type of "Stacked" 

    3. Add Metric C to the Values of the column / bar chart. Click on the hamburger icon next to its name > show on right axis

    4. Click the hamburger icon next to its name again > Series type > Line

    5. Apply changes 

    Hope this helps! 

     

    Thanks,

    Max 

    0
    Comment actions Permalink
  • Avatar
    Jessica Orlando

    Hi Max,

     

    Thank you! I learned this is a new feature from 8.0 and I am on 7.4 which is why I couldn't get it to work.

     

    Thanks!

    0
    Comment actions Permalink

Please sign in to leave a comment.