![]() Good luck! If you have any questions or suggestions on how to make it better, I’d love to hear it. In case you want to try it out, here is the Excel spreadsheet, and you can download the completed Tableau Public workbook by clicking “Download” in the bottom right corner of the workbook above. After that, I just made a simple table for the move notation and a “Hover for Instructions” image, and dropped everything into a Dashboard. I’m pretty sure there was a better way to do that, but ran out of time.Ħ. The only trick was the sorting – I wanted to sort based on the Points per 100 Games, but had to do so manually. Also added are the rank and the Pts/100 Games fields. This is basically just a stacked bar chart with some fancy formatting, but the starting point is a bar chart with the “Opening” field in the Rows shelf and the “Frequency” field in the Columns shelf, with the “Outcome” field in the Color shelf. A stacked bar chart was created for the chess opening outcomes as shown below:ĥa. The Quick Filters were added to limit the board view to one and only one opening (instead of showing all of them overlaid on one another, which just jumbles all the openings into one view).ĥ. Then it was a matter of choosing the “Chess” option from the “Select Shape Pallette:” drop down menu and assigning the right image to the right piece code (wk = white king, bk=black king, etc.).Ĥd. png format to the “My Tableau Repository” and “Shapes” folders in a new folder I created called “Chess”. I dragged the “Piece” field to the Shape shelf, clicked the down arrow in the “Piece” legend that appeared in the bottom left and selected “Edit Shape…”. ![]() They are naturally ambitious and very communicative, but not always the most sensitive. I added the chess board background image by selecting Map > Background Images > Add Image, browsing to the chess board image file location, setting the coordinates to -0.35 and 9.35 for both the x-axis and the y-axis, and selecting “Always Show Entire Image” in the Options tab. Because the Ruy Lopez is such a complex opening, its no surprise that its lovers also enjoy challenges, riddles, and puzzles of all kinds, and most of all want to know why things work the way they do. I added the “x-pos” field to the column shelf and the “y-pos” field to the row shelf and converted each from a SUM to a dimension (32 small circle shapes appeared in the general positions of the pieces).Ĥb. I started with the chess board view, which looks as follows:Ĥa. A chess board image and chess piece images were found using Google Image search.Ĥ. Once all of this was converted to an Excel spreadsheet, the win/draw/loss stats were added to each row, and the Tableau reshaping tool was used to convert the spreadsheet to prepare for connection with Tableau.ģ. wp1 = white’s first pawn, on square A2 to start the game):Ģ. ![]() The time-consuming part was converting each of the 20 openings in the viz from standard chess notation in the website to a spreadsheet structured as follows (each row corresponds to a specific piece on the board, e.g. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |