Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Product Spotfire
Categories Visualization
Created by Guest
Created on May 31, 2017

Sorting for waterfall plot

The new waterfall plot only allows a sorting within the categories of the Category Axis. However it  is lacking a functionality to sort the values based on the Value Axis which actually would make it "waterfall"-like. Could this please be added? Otherwise I find the new plot a bit useless.

  • Attach files
  • Guest
    Reply
    |
    Jun 17, 2021

    Essential feature. Lack of this makes waterfall chart unusable! Back to Excel

  • Guest
    Reply
    |
    Mar 29, 2021

    Since I've put this here, lots have happened and even forgot about it.

    The graph still 'feels' a little unnatural but here is a workaround for this 'problem':

    Go to options > colors > edit the expression exactly like this: "THEN If([CategoryIndex.X] in (0),null,[Y.FinalValue])".

    This means that now you can set the colors for 3 categories:

    1. Starting Bar [it will have the color of 'Empty values']

    2. Difference(s) Bar(s)

    3. Total Bar

  • Guest
    Reply
    |
    Mar 26, 2021

    It's a key feature we are talking about here!

    Sorting in waterfall would give such an edge to Spotfire compared to other softwares like Tableau! Think about how many people in finance and other services could make good use of this feature!

  • Guest
    Reply
    |
    Mar 4, 2019

    essential feature! First question asked for all people working in business: what variable has biggest impact?... now dificult to answer 

  • Guest
    Reply
    |
    Sep 17, 2018

    I do not know about others but I find myself in the following situation:

    The first column is with the Initial Total, then comes the differences and, in the end, the Total bar (final & automatic & optional)

    My need is about the coloring: my financial clients want me to color based on differences values (red for positive and green for negative) but the Total BARS (yes, both of them) to have their own colors.

     

    Thank you for your time !

  • Guest
    Reply
    |
    Sep 14, 2018

    Yes, please this is really important for waterfall charts, and seems easier to implement

  • Guest
    Reply
    |
    Aug 21, 2018

    Agree this feature would be a massive improvement to the waterfall plot