Pavinkumar R Posted February 15, 2023 Share Posted February 15, 2023 I've a data set similar to the one in below (X,Y & Condition). I've plotted line graph with color by 'Condition'. In the given example case, I've two plots (as there are two conditions 'A' and 'B').What I want to do now is, to create a single plot which shows the difference/sum/multiplication/division between these two plots. Basically, I want to understand if there is a way to add a calculated row similar to calculated column in Spotfire? Or Any other way, In which we can achieve what I'm looking for?Thanks in advance. Link to comment Share on other sites More sharing options...
Solution Gaia Paolini Posted February 15, 2023 Solution Share Posted February 15, 2023 From what you said, I would try to apply a pivot transformation to your data, then you can create as many column combinations in the plot as you need.I have slightly changed your sample data (the values for A were all 1, and the X values were repeated). See attached dxp.Basically I created a pivot table by adding a new data table (press + then choose 'Other' then choose the existing data table) so as not to overwrite the original, then applied a pivot transformation so that the resulting table looked like this (right):Then I plotted the pivoted table using as columns: Y_A, Y_B then Y_A-Y_B, Y_A+Y_B resulting in this plot: Link to comment Share on other sites More sharing options...
Pavinkumar R Posted March 1, 2023 Author Share Posted March 1, 2023 Thanks for the response. This is what I was looking for. Appreciate your help here ! 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