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


jharr

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.

 12/4/2018 6:24 AM
User is offline View Users Profile Print this message


MFS

Posts: 2
Joined: 9/7/2018

Yes, You are right when you link tables you need an aggregation method to visualize a column from another table.

There are two workarounds for that issue:

  1. You can select an aggregation method that not change your results (For example UniqueConcatenate).

  2. Or you can merge the tables to select the column without aggregation.

Regards,

Monica

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