Skip to Main Content
Spotfire Ideas Portal
537 VOTE
Status Implemented
Product Spotfire
Categories Visualization
Created by Guest
Created on Feb 6, 2016

Shared scales in line chart, combination chart and bar chart

I have a table with a contract amount of a sale, a discount amount of a sale and a total sale price which is contract amount + discount. I would like to chart the contract & discount amounts as a stacked bar chart with invoice month as the x-axis and the 2 amounts on the Y-axis. I also want to show the discount % (discount / total sale price) as a line on the same combination chart. However, because the amounts are in 100s of thousands or millions and the discount % is just a %, the Y-axis scale should have different scales (for the amount & for the %). However, I am not able to get the discount % scale uniquely assigned on the same Y-axis as a result the discount % is showing as a flat line all the way on the x-axis (since there is just one scale and the discount values are less than 100 and the amounts are all so large.

NOTE: some of the merged Ideas and comments to this Idea refer to other plot types than the Combination chart since in essence any plot type with multiple Y scales would benefit from this improvement.

Implemented in 10.9
  • ADMIN RESPONSE
    Apr 21, 2020

    Support for dual shared scales is implemented in Spotfire 10.9.

  • Attach files
  • Guest
    Reply
    |
    Apr 20, 2020

    The new functionality in 10.9 is great - easy to use and migrate existing charts to using dual scales.

    You took your time on this one TIBCO but for me the results are perfect!

  • Guest
    Reply
    |
    Apr 19, 2020

    It is really good to have this functionality -and a lot more- in a version prior to the next LTS so we can all test this and give feedback here and via TIBCO's and PerkinElmer's support (https://informatics.perkinelmer.com/Support/Contact/) for the LifeScience community. Please share your feedback and don't hold back. It is really good information and it can't be more timely.

  • Guest
    Reply
    |
    Apr 18, 2020

    Some progress in 10.9

    "Dual shared scales Spotfire visualizations that support multiple scales now also support shared dual scales. This means that you can create visualizations that display, for instance, 5 pressure values and 3 temperature values, using just two scales; one for pressure and one for temperature. This is available in the bar chart, line chart, combination chart, and scatter plot.

    Choose right or left scale position You can now select the scale position for visualizations that use just one scale. You can position the scale on the right or left side."

    Need to check out the behavior but looks useful so far.

  • Guest
    Reply
    |
    Apr 18, 2020

    Just a small note to everyone who is bashing Tibco for not being able to implement this for 4 years now: 4 years is only when the Ideas portal was created, and Tobias bulk imported all the previously raised pending Feature Requets from their previous method of tracking into this new site. So it is more than 4 years :) (to put it into context, less than 3 years was the difference between the initial release date of win8 and win10)

  • Guest
    Reply
    |
    Apr 16, 2020

    I agree with previous comments about how this seems to have be ignored in favour of other more minor changes.

    If the issue is one of trying to maintain comparability with the existing charts, why not do what was done when the map charts were changed- create a new visualisation type that co exists alongside the current one for a period of time?

    That way users can build new visualisations that use the new features and migrate older visuals to the new one themselves over time

  • Guest
    Reply
    |
    Apr 16, 2020

    And still no addressment from the product owner on where on the prioritization train this issue was,is, will be. Actually, they may not even have this on their development train. I hear this feature would touch many locals of the base code, but not much else.

  • Guest
    Reply
    |
    Apr 16, 2020

    Hi Niklas,

    The comments would make much more sense if the product was getting more features rather than rearranging the menus and the TABS. Do you realize how many analysis instructions and usability complaints we got as a result of the 10.x deployment when this HARD change was introduced.

    What IDEA request # was voted so high to put the page tabs at the bottom and increase the complexity to work with data tables. Who did the user experience and deployment impact testing testing on this one issue????

    When was the last time a new visualization interaction feature was introduced?

    The visualizations are what people see, and that's not changing. It really has now got to a point of resentment.

  • Admin
    Niklas Amberntsson
    Reply
    |
    Apr 16, 2020

    We are aware of the importance of this request, and understand that it is frustrating and may seem strange from the outside that we don't immediately address this and other long standing commonly requested features. Your input is very important to us. We review all new ideas, read every comment and frequently review top voted items to see how we can fit them into our development plans.

    Unfortunately it is not possible for us to address all top requests - at least not right away. Reasons include:

    - We are trying to strike a balance between transformational improvements like adding streaming data capabilities and polishing existing features like how the scales work in our visualizations.

    - Sometimes, while a feature request may seem small and easy to fix, we may need to first make a bigger change to make it possible to address the request, or to solve multiple requests in a more effective way.

    - When we add to an existing feature (like adding a new scaling option to an existing visualization) we also need to make sure that everything else works as expected when used together with the new capability. Since Spotfire is extremely interactive and responsive (The data can change at any time and the user can change the visualization at any time) this is sometimes quite complicated.

    Thank you.

    Niklas Amberntsson

    Senior Product Manager

  • Guest
    Reply
    |
    Apr 15, 2020

    You really need someone dedicated to customer feedback. This is far away from being professional.

  • Guest
    Reply
    |
    Apr 13, 2020

    Wow we are going on 4 years now.

  • Guest
    Reply
    |
    Apr 13, 2020

    So many years already.... Still no solution? So many other charting tools have done it and it is basic for them. I wonder why my company is still paying license money for this tool.

  • Guest
    Reply
    |
    Dec 3, 2019

    Please implement ASAP.

    The ability to have comparable figures on the same scale axis vs a % trend on the opposite is a fairly basic business requirement we need.

    Thank you for your time.

  • Guest
    Reply
    |
    Oct 1, 2019

    Hi Team,

     

    I've filed an Idea to represent multiple scales by color to be used in the combination chart with stacked bars and explain more about our own scenario.

     

    Here is the Idea number: TS-I-7387. Please merge it to this one if its discussing the same topic.

     

    Best Regards,

    Ghannam

  • Guest
    Reply
    |
    Sep 18, 2019

    Yes, would like to see the ability of left/right scales to have a single scale on each side. This is useful when graphing multiple variables with 2 different units. Requirement is for all variables on one axis to fall withing the same scale (max to min) and not to default to each individual scale range.  Manually setting the Max value for all variables in the properties doesn't work very well when there is a large variance in the underlying data which changes with filtering.

  • Guest
    Reply
    |
    Jul 13, 2019

    Thanks for the update Brad, looking forward to seeing what Tibco come up with for this. As is always the case with data analytics or software engineering, everything is always more complex than it looks from the outside! 

  • Guest
    Reply
    |
    Jul 12, 2019

    Hello all of you dedicated fans of this "shared scales" idea! This is Brad Hopper, I'm the VP of Product Strategy for TIBCO's analytics portfolio, including Spotfire. I wanted to respond to this thread to let you know that we are very aware of the strong desire for this capability in the product and have been doing research on what it will take to deliver a solution. As you can see the idea is market as "Under Consideration". We don't do that unless we are in fact looking into design considerations, engineering estimates, surrounding requirements etc. and investigating timing and prioritization. At the top of the thread you can also see that this idea has 11 merged ideas - as it turns out, there are a lot of considerations about this one that make it more challenging than it appears, although I'll admit it seems quite straightforward it touches several places in the codebase (and there are other work items we might like to combine with it) so there is more work to be done here. When we can share more we will, but in the meantime, don't hesitate to describe other cases in which shared scales will be useful for you, we are listening and taking notes. Thanks for your passion! - Brad

  • Guest
    Reply
    |
    Jul 6, 2019

    Not addressing this thread is bad business Tibco

  • Guest
    Reply
    |
    Jul 4, 2019

    Any news on that? More than three years already for such a basic functionality. 

  • Guest
    Reply
    |
    May 17, 2019

    I support the capability described above to be implemented ASAP.

  • Guest
    Reply
    |
    Apr 2, 2019

    I developed a workaround (I wouldn't call it a solution) that has proven helpful for addressing the need for a dual y axis with proper labels and shared grid lines. It relies on python scripts that look at the ranges needed for each axis and compromise on a good set of min and max values on either side that are nicely divided by 2,3,4 or 5 so that the grid lines end up with round numbers. I've shared this approach with Tibco and they've discussed building the functionality into the Combo Chart but I haven't heard any updates on that front for quite some time. Some typical charts are attached to demonstrate the end-result (notice the well-chosen axis labels on BOTH y axes).

    If anyone's interested in this approach, let me know and I could share the scripting details.  (paul_jones@keysight.com).

  • Load older comments
13 MERGED

Allow two series to use same y-axis

Merged
-Add the capability on a combination chart when charting three variables to have two of the variables share the same axis (without having 2 numbers for each appear) as only one y-axis measurement instead of showing both with the same data and havi...
over 8 years ago in Spotfire / Visualization 0 Implemented
17 MERGED

2 y-axis scales

Merged
No description provided
over 8 years ago in Spotfire 1 Implemented
5 MERGED

Set Individual Scaling in Visualization For Each Y-Axis

Merged
A nice feature for any of the visualizations with multiple y-axes would be an option for the "Multiple Scales" where "Individual Scaling" could be set to "For each y-axis" to force any channels positioned on each axis to keep the same scale range....
over 7 years ago in Spotfire / Visualization 5 Implemented
5 MERGED

Enhanced value scales in charts

Merged
I think the value scale option is quite weak at the moment. For instance it is not possible to group different variables in a single value scale. It is only possible to have a single scale per colour or per trellis panels. I think there should be ...
over 7 years ago in Spotfire / Visualization 1 Implemented
6 MERGED

Set the same scale collectively for multiple columns

Merged
In a visualization when multiple scale option, there are cases where I would like to set multiple columns to the same scale.Currently, it is necessary to set the scale of each column individually.It is very useful to be able to set the same scale ...
about 7 years ago in Spotfire / Visualization 3 Implemented
1 MERGED

In a combination chart, should be able to do multiple axis for Y axis, but limit it to Primary and Secondary

Merged
If we could have a combination chart that the left axis was one scale and the right axis was another scale and all items attached to these scales were the same that would be amazing. So we could have dollar amount on the left for bars and % on the...
almost 7 years ago in Spotfire / Visualization 0 Implemented
4 MERGED

Scale by Chart Type in Combination Chart (bar vs line)

Merged
Combination Chart (bar vs line) Y-axis has 2 individual scales, for each color and for each trellis panel.It would be convenient to have the option to select a scale per chart - a scale for bar chart and another scale for line chart.
about 6 years ago in Spotfire / Visualization 0 Implemented
2 MERGED

Autoscaling for multiple y-axis scales

Merged
Y axis scale (supporting visuals in attached document) I want multiple curves on the left Y axis share the same scale while other curves on the right Y axis share another same scale. Spotfire allows all curves to have a different scales or a sa...
about 5 years ago in Spotfire / Visualization 0 Implemented
1 MERGED

Select to show Y-axis labels

Merged
When creating a chart with multiple bars or lines, for every y-value the axis labels are shown. Even when the scale is the same for all different y-values. You can use a trick to change the format of some of the y-values to get rid of the y-axis l...
almost 8 years ago in Spotfire / Visualization 3 Implemented
11 MERGED

Another option for charts to have Y axis with Primary and Secondary Axis with single scale each

Merged
In a nutshell, this is default behavior for many other software charting applications and I'm really surprised Tibco hasn't added this feature yet. My proposal: There should be an in-between feature for Y-axis charts where "One axis with a single ...
about 7 years ago in Spotfire / Visualization 1 Implemented
2 MERGED

When using the " multiple axis" feature, have only a primary and secondary axis, even with more than two series plotted.

Merged
When using the "plot series on multiple axis" feature in the visualization axis properties. I want only a primary and secondary axis ONLY. Even if there is more than two series. For example, if I have four lines (each of different color) in a line...
almost 5 years ago in Spotfire 0 Implemented
4 MERGED

when using multiple scales in combination chart, allow user to categorize series and each category uses the same range and only show 1 number for each

Merged
Customer wants to do followings in combination chart when using multiple scales , (1) categorize series and each category shares the same range, lets say there are 2 percentage values and 2 amount values in Y axis, user wants to specify t...
over 4 years ago in Spotfire / Visualization 0 Implemented