Dan W Posted April 13, 2017 Share Posted April 13, 2017 Maybe I'm missing something, but when I have multiple Y axis Columns and click Multiple Scales, it creates a unique scale for each column, but what I really want is just one scale for the left side and one scale for the right side, with the columns fit together on the same respective scale. I feel like there's an feature missing here, like "Two axis with single respective scales". Hate to say this, but like the default behavior in Excel when creating a similar chart with Primary and Secondary axes, and I find myself sometimes exporting Spotfire data to Excel just take advantage of this one feature Excel has that I can't reproduce in Spotfire. A more tangible example would be a Combo Chart with Y-axis with Primary Axis columns in a Log Scale for (1) Line of Electricity generated (2) Line of Water consumption volume and then Secondary Axis in a Linear scale showing (3) Hours online per day or days per month as a bar chart behind the lines. A chart like this can visually show the correlation of electrical consumption vs. Water consumption, but I don't want independant Primary Axis columns. Does that make sense Edit: Added 2 screenshots to illustrate. With 2 variables on a Single Y Axis, the axis is properly scaled to show both of them on a Single axis. However, as soon as I add a variable to the secondary Y axis, I am forced to have each variable with its own axis. What I need are 2 Single Y Axis, one for the Primary and one for the Secondary, not multiple scales. With multiple scales, the graph looks like garbage and I am forced to either set hard limits, or just do it in Excel. The 3rd screenshot shows how this is done in Excel, which seems an obvious feature to have in Spotfire, but it doesn't exist. Link to comment Share on other sites More sharing options...
Shandilya Peddi Posted April 21, 2017 Share Posted April 21, 2017 Hello Hydrodan, You can select the position of the scales as below, Goto Visualization Properties > Y -axis > Select Multiple Scales > In the Individual Scale Settings select a scale > Select position Left Y axis or Right Y axis Link to comment Share on other sites More sharing options...
Dan W Posted May 2, 2017 Author Share Posted May 2, 2017 Shandilya, that doesn't solve my problem, because when you assign multiple scales it creates a unique scale for each variable. I was a single consolidated scale for the left axis and single consolidated scale for the right axis, no matter how many variables are on each axis. I want the variables to share a scale. Link to comment Share on other sites More sharing options...
Dan W Posted May 2, 2017 Author Share Posted May 2, 2017 Okay, I added some screenshots to the original comment to illustrate my question. Link to comment Share on other sites More sharing options...
Shandilya Peddi Posted May 3, 2017 Share Posted May 3, 2017 Hydrodan, Thank you for the screenshots now I understand your requirement. But currently it is not possible to get single scale for multiple axis. That would be an enhancement request. I would suggest you to create an enhancement request at https://ideas.tibco.com Link to comment Share on other sites More sharing options...
christopher sawtelle 2 Posted May 4, 2017 Share Posted May 4, 2017 Here is My Band-Aid tweak which you can use to make them disappear. Go to Properties --> Formatting ... here select any of the Y axis values you want to hide and then select "Custom" formatting, in the Format String box enter a space. This should make the Axis Value disappear. Link to comment Share on other sites More sharing options...
Dan W Posted May 8, 2017 Author Share Posted May 8, 2017 Thanks for the clarification - yes I've added an enhancement request. Based on the "Similar Questions" linke appearing on the right side of the screen, this appears to be a very common issue with other users. I'm quite surprised Tibco developers haven't added such a basic feature yet. Link to comment Share on other sites More sharing options...
Dan W Posted May 8, 2017 Author Share Posted May 8, 2017 I appreciate the feedback, but what I need is more subtle than just displaying a single axis, I need the data to all be scaled to a single axis. Thanks Link to comment Share on other sites More sharing options...
Jana Polley Posted November 28, 2017 Share Posted November 28, 2017 Hi, I'd have the same issue and would like to know what the status of this change request is. Thanks, Jana Link to comment Share on other sites More sharing options...
Eric Givens Posted April 23, 2018 Share Posted April 23, 2018 Has there been an enhancement I am encountering the same thing that other visualization tools handle with ease. Link to comment Share on other sites More sharing options...
Thien Ung Posted January 11, 2019 Share Posted January 11, 2019 This is a great enhancement request. Have you submitted it yet to Tibco's Spotfire Ideas portal https://ideas.tibco.com Link to comment Share on other sites More sharing options...
Ryan Fesler Posted January 25, 2019 Share Posted January 25, 2019 This would be insanely helpful. Seeq has this ability for every variable. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now