Map a column to two different columns in Info Window

mbosma — Thu, 18 Jan 2018 08:55:26 GMT

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

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

FredrikE — Fri, 19 Jan 2018 07:49:43 GMT

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

topic Re: Map a column to two different columns in Info Window in SAS Visual Analytics

Map a column to two different columns in Info Window

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