Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Product Spotfire
Categories Visualization
Created by Guest
Created on Feb 6, 2016

Allow Categorical expressions to reference columns in a secondary data table

As an analyst I want to use categorical expressions based on a secondary data table in my visualization. Using a column from a secondary data table in the Line By or Color By axis when the x and y axis are based on the primary data table yields this explanation of why this is not allowed:
* "Categorical expressions can only reference columns in the main data table"

*Details:*
The only way to do this currently is to "Insert > Columns" from secondary table to the primary data table so that they can be used in the visualization. This works but requires a duplication of data in the analysis which is not efficient when large amounts of data are in play.

  • ADMIN RESPONSE
    Apr 21, 2020

    In Spotfire 10.9 and later the Display values feature may be used to solve this issue if the data is suitable. For example an ID in the main data table may be used to group the data, while a more human friendly label in a secondary data table is displayed in the visualization.

  • Attach files
2 MERGED

Data tables for grouping - enable "shape by" option for multiple data tables.

Merged
Hi developers, The data table for group "Color by" /"Size by"/"Rotaion by" can be changed to any loaded table, but the data table for the group "Shape by" can not be changed. Is there any way to add the functionality to the Group "shape by", too. ...
over 4 years ago in Spotfire / Visualization 0 Future Consideration