Sometimes I have two or more pairs of measures that I want to plot on the same chart like this:
To do this in Spotfire today, you have to restructure the data so that there is only 1 set of x values and use Color by to "Line ID". Although this is a very simple solution, it actually forces you to combine 2 tables into 1 table. Spotfire works great with 1 table, but in a lot of complex cases people will not be working with just 1 table.
If the 2 data tables have to stay separate, then it becomes very difficult to plot. One solution is to use Lines and Curves, but often that is unsatisfactory if the user needs the added Line to have the same interactivity as a regular line on a line chart.
You could use a Column Match on the x value to allow you to plot 2 data tables on the same y axis. However if the x-axis values don't match exactly, the data point doesn't show up.
Thanks for posting my idea Tobias! This is my #1 ask of Spotfire. Please give us the simple functionality of having 2 sets of x and y on 1 plot while keeping data tables separate.