Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Map a column to two different columns in Info Window

Reply
New Contributor
Posts: 3

Map a column to two different columns in Info Window

[ Edited ]

Hello everyone,

 

I am using VA 7.2 and I have a question about mapping a column to two different columns in an Info Window. I know that a column can only be linked to one other column, so I tried duplicating the column and link the duplicate to the second column. However, I want to display all the rows where either the first column equals the chosen value or the second column equals the chosen value. Let me illustrate the problem with a simple example. I have 5 players that play a simple game (coinflip), and I want to see all the games a player has played by clicking on the player. Let the List Table containing the players be given by:

 

Player      Wins

A              3

B              1

C              0

D              2

E              1

 

Now, I want to click on the row for player A and see all the games played by player A. So I want to have an Info Window, containing a List Table that looks like this:

 

Player 1     Player2     Winner   

A                B                1 

A                D                2 

E                A                1 

A                C                1 

B                A                2

 

Hence, I want to map the column Player from the first List Table to Player 1 and Player 2 in the second List Table. However, by duplicating the column Player, and linking one to Player 1 and one to Player 2, the Info Window will only show the rows where both Player 1 and Player 2 are equal to A, which are none. I know a solution could be to duplicate the entire dataset with games and create 2 rows for every game and write both players once as player 1. However, I prefer not to duplicate the data set due to its size, and the 2 columns do have a different interpretation in my data set. 

 

Does anybody have an other solution how to achieve this?

 

Thanks in advance.

 

Mick

PROC Star
Posts: 401

Re: Map a column to two different columns in Info Window

I can't see an easy solution unless you upgrade to 7.4. There you can use parameters to filter your list and inthe filter you can specify "player1 eq [parameter] or player2 eq [parameter]".

 

Could your solution be that you use two lists in your info window, one for each player?

 

//Fredrik

Ask a Question
Discussion stats
  • 1 reply
  • 115 views
  • 0 likes
  • 2 in conversation