Dashboardplus, outsourcing labour, markov models, and more!

Patch Notes

The big changes in this release are the switch to using {shinydashboardplus}, moving much of the data processing from the R client to the PostgreSQL server (largely via views), the addition of a Markov Chain model to predict winners, and an expansion of the available leaderboard and player-level stats.

UI

• Switch to dashboardplus - ae3538d
• Switch leaderboard outputs from using gt to {reactable} - c906599
• Adds a tab to display the results of simulated game data

Functionality

• Add player stats tab - 74bf158
• Add teammate performance table to player stats - 0eb4def
• Add arena selection dropdown - 85dcb88
• Track 1812 casualties - 617d31e
• Model and display predicted win probabilities using markov-chain-based simulation data, for players with a history of playing on the same team- 5928ec1
• Display players' game history in player stats tab - 6d929e6
• Add modal dialog when undo score is pressed - 5624b8a

Backend

• Source teammate_stats data from SQL view instead of processing data in R - 29ff848
• Utilize reactivePoll() to periodically refresh our data and keep the leaderboard/player stats updated with each completed game - 380a238
• Source score_progression data from SQL view instead of processing data in R - d19a8cd

Testing a webhook, first second try!

Game Summary Update

Patch Notes

UI

• Add Game Summary (working title) button to view a live summary of player performance. Game Summary will compare player performance in the active game to past performance in games with matching team sizes. When the active game has not been completed, the summary will use prior scores data up to the active game's round i.e. if the game is in 12A, only scores data at or before 12A is used for comparison. When the game has been completed, all scores data in equivalent team size games is used - d0603e4
• Change button colours to alternate with the active team - de2221a
• Add a die icon to denote the active team - 8c108f0
• Mirror axes for Score Heatmap in Career Stats - 6a5f423
• Change button styling to use relative measures instead of absolute - 11523ec
• Update leaderboard sorting to include first players with 5 or more games then sort by total points, and which attributes are shown - a09c48f, 6a49d80

Functionality

• Switch sides automatically at halftime - 69efbf3
• Fix rebuttal to allow teams to exit rebuttal immediately upon scoring a point - 7a461dc
• Update dplyr verb syntax to utilize changes in 1.0 - 3bb5895
• Fixes score validation to allow players to keep shooting in rebuttal - 29dec3a

Backend

• Fix issue causing us to undercount players' total shots - 2297b86
• Added last_round column to game_stats

SnappaScoreboard 0.55

Patch Notes

UI

• Slightly improve notification boxes (needs more work)
• Increase duration and add team colour to notifications - (317de26, c70dd25)
• Added a little styling to message received when there is an incomplete game - bef0fdf
• Updated leaderboard layout, highlighting only players who have played at least 5 games - ffce5a7

Functionality

• Fixes bug where Recent Scores button would not work after switching sides - bc954e4
• Halftime pop-up occurs at 21 - e665631
• Halftime memes

Backend

• Functionalized data processing for leaderboard table - 8861369
• Switched from using dbplyr's tbl() to DBI's dbGetQuery() for much needed performance updates - (49b70f9, 01749f1, cc6319e, + more)
• Added and/or updated foreign key constraints in the scores and player_stats tables - 85ea323

SnappaScoreboard 0.51

Technically our first release, but because we have had a number of informal versions we'll start off at 0.51.

Patch Notes

UI

• Converted plotting theme function to use the structure of @isabellabenabaye's theme function in her {ib} package.
• Created a table theme too
• Further iPad UI optimization
• Reordered Next Round/Previous Round buttons to give greater emphasis to Next Round
• Simplified Score Heatmap
• Added text indicating the current round when scoring

Functionality

• Fixed bug where app was crashing when undoing previous score
• Fixed bug where app would crash on pressing previous round when no scores had occurred