I created a ‘coach view’ using Tableau in 2017. This was useful to provide a snapshot of our upcoming matches to help us determine our match strategy for an upcoming match. Here’s a screenshot of what it looked like:
Some explanation: Teams were populated on the screen by using a match selector in the top left. Each alliance had a set of total score averages for gears, fuel, and climb at the top. For gears, I also added lines to mark the breakpoints for each rotor.
When you selected/hovered over a team number, their stats would be highlighted (I couldn’t figure out how to have the graphs line up with a team’s positions. Graphs were ordered by team number, so this was a workaround). Each graph represented the team’s performance over the competition, which was useful for trend analysis (e.g. If a team was zig-zagging, they were probably inconsistent, if they were trending upwards, it meant they were improving as the competition went on, etc.). For gears, the line across the team’s graph for each stat represented the entire team’s average, and there was an individual line per team for teh team’s own average (kind of hard to see in the image since I’m highlighting my team).
Note that the data would not filter as a snapshot of the data before/during the match, so it just filled it with all the data we collected, so looking at QM1 would have data from the team across all the future matches as well.
All the data was populated using a custom-made scouting app I did back then, which would send the data to a Firebase database. I then had a google sheet with a script that would pull the data from the scouting app into it so that Tableau could see it. Tableau isn’t able to connect to Firebase directly, so this was another workaround. Images were also uploaded to the Firebase database and they populated a url that Firebase could pull to get a team’s image. The OPR/DPR/CCWM was pulled into the google sheets using TBA’s API.
As a note, I totally forgot how I did all this since I hadn’t touched this stuff since 2017. I’ll probably look into it again for 2020.
If you’re interested, here’s a standalone copy of the Tableau Worksheet that doesn’t require a google sheets connection.
Tableau Dashboard Test 2 (Google Sheets) (4k Res).twbx (134.0 KB)