Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Product Spotfire
Categories Visualization
Created by Guest
Created on Mar 25, 2020

Plot data from two tables in the same coordinate system without restructuring the data

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.

  • Attach files
  • Guest
    Reply
    |
    Mar 31, 2020

    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.