I'm creating goal build-up charts in Tableau and have encountered one issue with the data that I can't quite work out how to overcome.
I've got a number of rows for each part of the build up, representing the players and their involvement in the goal. Currently my data has the position from where they play a pass/cross or take a shot in the form of start position x and y and end position x and y. I've split the two parts and stacked on top of each other and created a path so that I can draw the lines, as seen below.
The issue I have is that after receiving a pass, some players move with the ball before passing it on and this isn't captured in the data. I can get round this by calculating a rolling path id for each of the points to connect all of them (i.e. point 1 is path 1, point 5 is path 5 and so on) but the visualisation is confusing and I'd like to be able to better draw attention to the players movement.
The way I thought of to get round this is to draw lines between the previous XY and the new XY and then split them into numerous lines to create a dashed line effect. However, I can't work out how I would be able to do this, as it would involve creating new rows and inserting them between the existing rows.
Does anyone have any ideas about the best approach for 1) creating these additional rows and 2) splitting the newly created lines? Much obliged!
