League of Legends summoner stats dashboard

This handy dashboard displays my most important League of Legends summoner stats in one cool view, so I can see at a glance how well (or badly) I’ve been performing in my recent games.

Elliott Lamb

Customer Support Engineer

Challenge

Although basic game stats such as wins and losses are available within the game client, other useful info is scattered across third-party channels – op.gg, Riot Games, Dot Esports – and can be tricky to find.

Checking multiple sites for the information I need takes a lot of time (especially if I get distracted browsing the latest Prestige skins in the Mythic shop) and they don’t include visualizations, or a way to customize the data.

Manually calculating my KDA average gets pretty tedious, especially when I’ve already spent a while searching for champion updates on Dot Esports.

What I really wanted was a way to pull all of this information into one place so I can just focus on the games ahead.

Solution

With this SquaredUp dashboard,I can now easily reflect on my individual performance, wins and losses as a team, and the latest free character offerings, all in one place.

It was super easy to set-up, I just collected data from Riot Games, Dot Esports, op.gg and the game client using the PowerShell plugin. Due to a few quirks with the Riot Games API, I had to reply on some PowerShell scripts to retrieve my metrics. Most of this information would usually be nested or difficult to access without making direct calls to the API.

Now I can easily see my stats at a glance, without having to trawl through blogs and make manual calculations.

Plus, I can easily share the link to this dashboard with my team and start strategizing ahead of the next game!

Dashboard walk-through

Here’s a quick run through of the different tiles and why they’re useful:

TheWin rate donut tile clearly shows how many wins and losses I’ve had in my last 20 matches. Using an API request, SquaredUp retrieved a list of recent match IDs and performance stats associated with my username.

This then returns a true / false value which I used to store two lists: one for ‘wins’ and a second for ‘losses’. I chose to present this with a donut tile for a clear overview of my wins and losses.

The Recent Champions played tile uses a bar chart to show which champions (characters) I’ve played in the last 20 matches, and how many times I played each of them.

Using the same Match IDs and stats as before, I simply used this data to add the champion I played in each match to an array. I included an incremented integer to group multiple matches with the same champion together, rather than treating them as separate values.

The bar graph makes it clear who the most played characters are and which ones are performing well. This helps me decide who I should play next.

TheKDAdonut tile represents my total number of Kills, Deaths and Assists in my last 20 matches, and the KDA average uses a scalar tile to shows my average number per game.

These stats both make use of the same script, but the KDA average is calculated within the SQL Analytics editor.

This average is an easy way of showing my in-game performance, with a higher number representing a better performance, and a lower number suggesting there’s room for improvement!

League of Legends rotates several champions every two weeks that you can play as, without having to unlock them using experience points.

If you play the game, you’ll know that it can take hundreds of hours to collect all champions without spending your hard-earned cash. So the weekly free champion rotations provided by Riot Games are great for trying them all before committing to buy.

That’s why I created the free champion rotation donut tile. It clearly displays the list of champions that are currently available, without having to head over to Riot Games.

This tile took a little more work than the others as the API retrieves a list of the numerical champion IDs, not their names. To work around this, I connected to the API of another site which provided a list of IDs and the associated champion names. I added these to an array along with a number ‘1’ with each value to allow the donut visualization to be used.

This is useful when viewed in combination with the champion experience tile. This shows which champions I have more strength and achievements in, and which need some improvement before they are played in competitive modes.

Before starting a game, it’s helpful to know if any server issues are likely to interrupt it. Using a status block tile, a simple red, amber, or green colour indicator lets me know the status of the EU server I play on. If there was a serious issue, it might not be possible to access the client or website, so it’s useful to see that information displayed on this dashboard.

The matches played by datetile allows me to see how many games I’ve played on any given day, so I can easily see if I’m spending too much time playing!

To get this data I simply retrieved a list of recent match IDs and stats, manipulating the time to show as 00:00, and grouping them by day. The line graph visualization is a great way to see trends and gameplay over time.

Like the ‘Free champion rotation’ metric, the Champion level tile shows which champions I’ve been performing well with. If I want to ‘level-up’ beyond a level 5, I’ll need several perfect games, so any champions at level 6 or 7 are the ones I’m more experienced with.

The great thing about using SquaredUp to visualize my summoner stats is that this is just the start, the PowerShell plugin lets you connect to just about anythingat all. My teammates will love it too!