PerkinElmer Informatics Support Forum
Decrease font size
Increase font size
Topic Title: Spotfire multiple data tables
Topic Summary: visualizing data from 2 tables that are linked through a 3rd
Created On: 10/9/2015 12:20 PM
Status Post and Reply
Linear : Threading : Single : Branch
Topic Tools Topic Tools
View topic in raw text format. Print this topic.
 10/9/2015 12:20 PM
User is offline View Users Profile Print this message


Posts: 3
Joined: 2/3/2012

I have data in 2 tables (A and B) that are linked to each other through a third table (C). So all three tables share one column. I want to make a scatter plot that will have axes from categorical columns in table A, but marker by, color by and size by categorical columns in table B. How is this done? I have tried using each table as the 'main' table for the plot, but when I go to set an axis to [A].[column], it complains that I have to aggregate the data. It's categorical data, so aggregation in this context doesn't make sense.

Help is appreciated.

FuseTalk Basic Edition v4.0 - © 1999-2018 FuseTalk Inc. All rights reserved.