Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Product Spotfire
Categories Visualization
Created by Guest
Created on Sep 12, 2016

Show total for stacked bar chart with both positive and negative values

Today, bar totals on stacked bar charts with both positive and negative values will show a total separately for the positive and negative bar... but why can't we just show a total? One total value for the bar... 

Would be good to have that option in the label set up... 

  • Attach files
  • Guest
    Reply
    |
    Jul 23, 2023

    Any updates on this one when we can expect this one comes up it is very long pending . 7 yrs and no change in implementation is very frustrating.

  • Guest
    Reply
    |
    Oct 8, 2021

    The workaround using trellis is not useful when you use two or more tables in the Yaxis.

  • Guest
    Reply
    |
    May 3, 2018

    This is a big deal...We must fix this.  Send ideas to work-a-round this.

  • Admin
    Niklas Amberntsson
    Reply
    |
    Jun 12, 2017

    There is a workaround for this, which is using trellis panel headers to display the total of all segments of the stacked bar. It can be achieved by using an expression on the trellis axis to compute the value and to concatenate it with the name of the category.

    The expression I used was this: [Division] & " - " & Integer(Sum([Value]) OVER ([Division]))

  • Admin
    Niklas Amberntsson
    Reply
    |
    Jun 12, 2017

    Does anyone have a suggestion for how to visually display the total? Just replacing the current label with a total computed as the sum of the positive and negative segments could be equally confusing?

  • Guest
    Reply
    |
    Mar 13, 2017

    I ran into the same issue; it is very deceiving to the end user to have the totals separated. I hope this enhancement gets implemented soon. Thanks!

  • Guest
    Reply
    |
    Jan 25, 2017

    I think it is crazy to not have a total with the positive and negative numbers.  It makes the stacked bar charts unusable when you have both positive and negative numbers.

  • Guest
    Reply
    |
    Jan 4, 2017

    I just ran into this issue, and I cannot believe they total separately.  It makes absolutely no sense.  This should be changed as soon as possible or another option provided.