Mark More Rows Based on Different Column

[Noah Holihan]

Hi all,

I have an issue where I am trying to mark all cells in a column when I select one of those. Here's an example:

 

 

 

Type

Color

 

 

A

Red

 

 

A

Orange

 

 

A

Yellow

 

 

B

Blue

 

 

B

Green

 

 

B

Purple

 

 

 

So, what I want is to have one chart that has all of the colors listed and the appropriate values next to them. When selecting one of the buildings for marking another chart will show all colors of the type. For instance, if red was selected on the first chart, then red, orange, and yellow would be shown on the other.

 

Any help would be greatly appreciated. Thanks!

[Shashank Gurnalkar]

Hello Noah,

 

 

You can use the IronPython script to take the marked value from the first visualization into a document property and then you can limit the data in the second visualization with the value from the document property. I have attached the analysis file for your reference.

 

 

Reference:https://community.spotfire.com/wiki/how-retrieve-data-marking-selection-using-ironpython-tibco-spotfire