However, in the second column, I only want to select, one player for and then add the statistics. However, I can’t and it selects all the players so the chart is a big mess. How do I select an individual player?
I want organise the left side & right side by counts, and colour the bars according to whether the shot was assisted.
For example for the picture below, The player on name is on the left, the zone is in the middle, and the assist, is connected to a plate name. The stuff in grey, is the # shots that were not assisted for each zone and they are connect to a grey column without a player name (on the right).
I need help manipulating the data so I can create sunburst charts to mimic the following.
I added the domain calculator before the color manager and connected it to the column resorter on the left and the color manger on the right. In it I unchecked the “restrcit number of possible values” and selected assist, player, shot_zone, and count*(shot_made). Is that right?
Also, How did you select a specific player for the sunburst chart? When I display mine its all the players?
And plus this is the type of output I am getting.Documents.xlsx (985.0 KB)
Ok, I think I got it to work. The last thing I am confused about is, if I am displaying the total shots that weren’t assisted as well? Because in the parraell coordinates graph above, the great lines are showing the total # that weren’t assited in each zone.
And regarding this comment “Seems so. Only why adding shot_zone and count*(shot_made) columns?”
I am guessing in the domain calculator all I have to select is player and assist and leave out shot_zone and count*(shot_made).