2c:null 2d:["$","title",null,{"children":"ALGS Split 2 Playoffs | ggwp | Observable"}] 32:T9e0,{ const roundNames = ["Group stage 1","Group stage 2","Group stage3", "Winners", "Losers1", "Losers2", "Final"]; function getGameName(roundno, gameno) { let x = ''; if (gameno === 0) { x += roundNames[roundno]; } x += "-" + gameno; return x; } let plotdata = game_scores.filter(x=>x.name === selectedTeam).map(function(x){ return {roundidx:x.roundidx, gameidx0:x.gameidx0, points:x.points, imgy: x.points+5, gamemap:x.gamemap, gameName: getGameName(x.roundidx, x.gameidx), img: x.gamemap === 'Storm Point' ? blueDonutUrl : orangeDonutUrl} }); let layer_points = vl.markBar({width:13, align:'left', tooltip:true}) .data(plotdata) .encode( vl.x().fieldQ('gameidx0').axis({titleFontSize:20, labelFontSize:20, values:[0,6,12,18, 24,30, 36], title:false, labelExpr:'datum.label == 0 ? "Group 1": datum.label == 18 ? "Winners": datum.label==24?"Losers1" : datum.label==36 ? "Final": datum.label==30?"Losers2": datum.label==6 ? "2" : datum.label==12 ? "3":"" ', labelAlign:"left",gridWidth:5}), vl.y().fieldQ('points'), vl.color().fieldN('gamemap').legend({labelFontSize:15, title: 'Game Map', titleFontSize:14}) .scale({range:['#5d8d74','#fc6c7b']}) ); let layer_donut = vl.markImage({width:17, align:'left'}) .data( plotdata.filter(x=> x.points===0) ) .encode( vl.x().fieldQ('gameidx0').scale({domainMin:0, rangeMin:0, domainMax:44}), vl.y().fieldQ('imgy').axis({title:'Points', labelFontSize:15, titleFontSize:20}), vl.url().fieldN('img') ); let chart_allgame_scores = vl.layer([layer_points, layer_donut]) .width(650).height(200); let rounds = vl.data( round_standings.filter(x=>x.name === selectedTeam).map(function (x) { return {roundidx:x.roundidx, round_rank:x.round_rank+1, roundName:roundNames[x.roundidx]}; }) ) .encode( vl.x().fieldN('roundName').sort(roundNames).axis({labelAngle:-45, labelFontSize:15, title:false}) .scale({domain:roundNames}), vl.y().fieldQ('round_rank').sort('descending').axis({ values:[1, 5, 10, 15, 20], titleFontSize:20, title: "Rank", labelFontSize:15}).scale({domainMax:20}) ) .layer( vl.markLine({strokeWidth:3}), vl.markCircle({size:150, tooltip:true}) ) .width(200) .height(200) return vl.concat([rounds, chart_allgame_scores,]).render(); }33:T72f,graphCompare = { const height = 500; const width = 180; let chartMeanPoints = vl.data(teamsummary) .encode( vl.x().fieldQ('meanPoints').axis({format:".0f", labelFontSize:20, titleFontSize:20, title:"Average points per game"}), vl.y().fieldN('name').sort("-x").axis({title:"",labels:true,ticks:false, labelFontSize:13}), ).layer( vl.markBar({tooltip:true}) .encode( vl.color({scale:{range: ["DarkGray", "OrangeRed"]}}).fieldN('selected').legend({disable:true}), vl.tooltip([vl.fieldN('name'), vl.fieldQ('meanPoints')]) ), ).height(height).width(width); let chartMeanKills = vl.data(teamsummary) .encode( vl.x().fieldQ('meanKills').axis({format:".0f", labelFontSize:20, titleFontSize:20, title:"Average kills per game"}), vl.y().fieldN('name').sort("-x").axis({title:"",labels:true,ticks:false, labelFontSize:13}), ).layer( vl.markBar({tooltip:true}) .encode( vl.color({scale:{range: ["gray", "black", "teal"]}}).fieldN('selected').legend({disable:true}), vl.tooltip([vl.fieldN('name'), vl.fieldQ('meanKills')]) ), ).height(height).width(width); let chartMeanPlacement = vl.data(teamsummary) .encode( vl.x().fieldQ('meanPlacement').axis({format:".0f", labelFontSize:20, titleFontSize:20, title:"Average Placement"}), vl.y().fieldN('name').sort("x").axis({title:"",labels:true,ticks:false, labelFontSize:13}), ).layer( vl.markBar({tooltip:true}) .encode( vl.color({scale:{range: ["gray", "FF4E62", "teal"]}}).fieldN('selected').legend({disable:true}), vl.tooltip([vl.fieldN('name'), vl.fieldQ('meanPlacement')]) ), ).height(height).width(width); return vl.hconcat([chartMeanPoints,chartMeanPlacement,chartMeanKills]).render(); }34:[{"id":"b23696811966a52be82bc92edcbc037a8381d4c23f56a95851875571f357736ced7ad19f88b5e44ba58da277fe443a74b10996d36107e65700b62bae1a21fbd3","href":"https://static.observableusercontent.com/files/b23696811966a52be82bc92edcbc037a8381d4c23f56a95851875571f357736ced7ad19f88b5e44ba58da277fe443a74b10996d36107e65700b62bae1a21fbd3","name":"algs2022split2playoffs.json","type":"application/json","lastModified":1651695087706.652,"size":771658},{"id":"99e4cef1905c906b41e9bc5cd6aabdddba8bb75426d9fa3a77530ffcc5958bf0a42ae77d891dd234c4e67d8adf6e19edcd802da6fa16049f57b11de3a2aa99d3","href":"https://static.observableusercontent.com/files/99e4cef1905c906b41e9bc5cd6aabdddba8bb75426d9fa3a77530ffcc5958bf0a42ae77d891dd234c4e67d8adf6e19edcd802da6fa16049f57b11de3a2aa99d3","name":"donut-2.png","type":"image/png","lastModified":1651671896007.109,"size":12521},{"id":"0faa5511543de6e5e1ac0012649d74cf11b9b48ceeb5b2cf4224c34aa12b8eb8b1df6a64e045460b2394bd7d0df4300f7c67ebafc46d5fa6c184390c86be9f36","href":"https://static.observableusercontent.com/files/0faa5511543de6e5e1ac0012649d74cf11b9b48ceeb5b2cf4224c34aa12b8eb8b1df6a64e045460b2394bd7d0df4300f7c67ebafc46d5fa6c184390c86be9f36","name":"donut-3.png","type":"image/png","lastModified":1651695637052.267,"size":19042},{"id":"950e512efec8e83fa346b87bfe894686461906f1a74033d4c66ca476c9b478291547d04403d13490409ab0fb18863cabaf7df17b2a38404ceab189682d67cf92","href":"https://static.observableusercontent.com/files/950e512efec8e83fa346b87bfe894686461906f1a74033d4c66ca476c9b478291547d04403d13490409ab0fb18863cabaf7df17b2a38404ceab189682d67cf92","name":"logos.min.json","type":"application/json","lastModified":1651666301645.753,"size":8625}] 30:{"id":"0236d4d750f9e37e","slug":"algs-split-2-playoffs","title":"ALGS Split 2 Playoffs","thumbnail":"2c700038f8b823521f954a1d27d8839e79603af5661d57a1868727722dcda0e2","access_level":"public","create_time":"$D2022-05-02T16:30:04.000Z","update_time":"$D2022-05-06T10:08:35.972Z","view_time":null,"first_public_time":"$D2022-05-04T20:42:54.154Z","has_unpublished_edits":null,"fork":{"id":"ce40b1e581c2e548","slug":"algs-split-2-playoffs-day-1-group-stage-kill-leaderboard","title":"ALGS Split 2 Playoffs Day 1 Group Stage Kill Leaderboard","owner":{"id":"6d4c89a26d98d78e","login":"ggwp","name":""}},"stars":0,"starred":false,"owner":{"type":"team","id":"6d4c89a26d98d78e","login":"ggwp","name":"","avatar_url":null,"tier":"starter_2024","bio":""},"version":2252,"publish_version":2252,"role":null,"authored":false,"authors":[{"type":"individual","id":"45e3a39aea4c7ff3","login":"ggwp","name":"","avatar_url":null,"tier":null,"bio":""}],"members":[{"type":"individual","id":"45e3a39aea4c7ff3","login":"ggwp","name":"","avatar_url":null,"tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"titling":"auto","title":"ALGS Split 2 Playoffs","cells":[{"id":0,"value":"# ALGS Split 2 Playoffs\n## Team Report Card","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":800,"value":"viewof selectedTeam = {\n const teamnames = aq.from(game_scores).groupby('name').rollup({name: op.any('name')}).objects().map(x=>x.name).sort();\n return Inputs.select(teamnames, {label: \"Select team\", size:200, value:\"Reignite\"});\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1581,"value":"html`\n

\n${selectedTeam}\nfinished ${rankText(finalRoundStanding)} in the ${finalRoundName}.\nThey played ${ngamesPlayed} games in total and won ${ngamesWonText}.\n\nOn average, they placed ${thisTeamSummary.meanPlacement.toFixed(1)}th and gained ${thisTeamSummary.meanKills.toFixed(1)} kills per game, earning ${thisTeamSummary.meanPoints.toFixed(2)} points.\nTheir best game was a ${thisTeamSummary.maxPoints} point banger.\n\n

\n\nTheir best fragger was ${topfragger.name}, who snags ${topfragger.meanKillsPerGame.toFixed(2)} kills per game and is top ${topfragger.meanKillsRank} out of 120 players.\n\n

\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1319,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1876,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1991,"value":"thisTeamPlayerKillsSummary.rename({\n totalKills:'Total Kills',\n meanKillsPerGame:'Average Kills Per Game',\n meanKillsRank: 'Average Kills Rank'\n}).view({maxdigits:2})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2072,"value":"# Attributions","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":2077,"value":"Data public at [Battlefy](https://battlefy.com/apex-legends-global-series-year-2/pro-league-split-2-playoffs).","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":2059,"value":"html`Donuts icons created by Freepik - Flaticon`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":574,"value":"# Under the hood","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":65,"value":"function get_playerkills_game(game) {\n if (game.state === \"complete\" ) {\n return game.results.flatMap(function (result) {\n return result.players.map(function (x) {\n // add team names\n x[\"team\"] = result.name;\n // ad-hoc fix for aDRacoon\n if (x[\"team\"] == 'aDRaccoon') {\n if ((x[\"name\"] === 'Rid_KaronPe') || (x[\"name\"] === 'Selly_o')) {\n x[\"name\"] = 'aDR_KaronPe';\n }\n if (x[\"name\"] === 'obly_aD') {\n x[\"name\"] = \"aDR_obly\";\n }\n if (x[\"name\"] === 'aD_Parkha') {\n x[\"name\"] = \"aDR_Parkha\";\n }\n \n }\n return x;\n })\n }); \n }\n else {\n return [];\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1661,"value":"playerKillsSummary = aq.from(get_playerkills_matches(d))\n .groupby(['team','name'])\n .rollup({totalKills:op.sum('kills'), meanKillsPerGame:op.mean('kills')})\n .orderby(aq.desc('meanKillsPerGame'))\n .derive({meanKillsRank: op.rank('meanKillsPerGame')})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1681,"value":"thisTeamPlayerKillsSummary = playerKillsSummary.filter(aq.escape(x=>x.team == selectedTeam)).orderby(aq.desc('meanKillsPerGame'))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1850,"value":"topfragger = thisTeamPlayerKillsSummary.objects()[0]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1536,"value":"teamsummary = {\n let tt = aq.from(game_scores).derive({\n won: x=>x.placement==1 ? 1 : 0,\n top5: x=>x.placement<6 ? 1 : 0,\n placementPoint: x=>x.points - x.kills\n}).groupby('name').rollup({\n maxKills:op.max('kills'),\n maxPoints:op.max('points'),\n meanPoints:op.mean('points'),\n stdPoints:op.stdev('points'),\n maxPlacement:op.min('placement'),\n medianPlacement:op.median('placement'),\n meanPlacement:op.mean('placement'),\n meanPlacementPoint:op.mean('placementPoint'),\n meanKills:op.mean('kills'),\n gamesWon: op.sum('won'),\n topFiveFraction: op.mean('top5')\n});\n tt = tt.assign({selected: tt.array('name').map(x=>x==selectedTeam?1:0)});\n return tt;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1622,"value":"thisTeamSummary = teamsummary.objects().filter(x=>x.name === selectedTeam)[0]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1587,"value":"finalRoundStanding = {\n let ranks = round_standings.filter(x=>x.name === selectedTeam).map(x=>x.round_rank);\n return ranks[ranks.length-1];\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1597,"value":"finalRoundName = {\n const fullRoundNames = ['','','','Winners round', 'Losers round 1', 'Losers round 2', 'Final round'];\n let x = round_standings.filter(x=>x.name === selectedTeam).map(x=>x.roundidx);\n return fullRoundNames[x[x.length-1]];\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1601,"value":"ngamesPlayed = {\n return game_scores.filter(x=>x.name === selectedTeam).length;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1589,"value":"function rankText(x) {\n if (x==0) {\n return \"1st\";\n }\n if (x==1) {\n return \"2nd\";\n }\n if (x==2) {\n return \"3rd\";\n }\n else {\n return (x+1) + \"th\";\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1519,"value":"ngamesWonText = {\n let games_won = game_scores.filter(x=>x.name === selectedTeam).filter(x=>x.placement===1).length;\n if (games_won === 1) {\n return \"one time\";\n }\n return games_won + ' times';\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1769,"value":"html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2027,"value":"d = FileAttachment(\"algs2022split2playoffs.json\").json()\n// Code to pull data in the first place\n// d = {\n// let dd = [];\n// for (var x of [[0,0],[0,1],[1,2],[1,3],[2,4],[2,5]]) {\n// let c = await d3.json(`https://tournament-structure.battlefy.com/views/apex-legends/global-series-season-2/round-robin/viewer-match?structureID=626ae53daca115766fe60017&roundNumber=${x[0]}&matchNumber=${x[1]}&disableSnapshot=true`);\n// c.roundidx = x[0];\n// dd.push(c);\n// }\n// for (var x of [[0,0, 3],[0,1, 4],[1,2, 5],[2,3, 6]]) {\n// // console.log(x);\n// let c = await d3.json(`https://tournament-structure.battlefy.com/views/apex-legends/global-series-season-2/double-elim/viewer-match?structureID=626ae56baca115766fe6001b&roundNumber=${x[0]}&matchNumber=${x[1]}&disableSnapshot=true`);\n// c.roundidx = x[2];\n// dd.push(c);\n// }\n// return dd;\n// }","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":679,"value":"round_standings = {\n return d.flatMap(function (m) {\n var standings = m.standings;\n standings.forEach(function(row, index) {\n row.round_rank = index;\n row.roundidx = m.roundidx;\n if (row.name === 'TeamLiquid') {\n row.name = 'Team Liquid';\n }\n });\n return standings;\n });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":719,"value":"game_scores = {\n return d.flatMap(function (m) {\n var i = 0;\n var scores = m.games.flatMap(function (g) {\n var results = g.results;\n results.forEach(function(row, index) {\n if (row.name === 'TeamLiquid') {\n row.name = 'Team Liquid';\n }\n row.roundidx = m.roundidx;\n row.gamemap = g.map;\n row.gameidx = index;\n row.game_rank = index;\n row.gameidx0 = m.roundidx*6 + i;\n });\n i += 1;\n return results;\n });\n return scores;\n });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":285,"value":"function get_playerkills_matches(matches) {\n return matches.flatMap(m => m.games.flatMap(g => get_playerkills_game(g)));\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":882,"value":"logos = FileAttachment(\"logos.min.json\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":884,"value":"function get_logoUrl(name) {\n let x = logos.filter(x=>x.name === selectedTeam);\n if (x.length == 0) {\n return \"https://cdn.battlefy.com/apex-legends-global-series-year-2/images/apex-icon.png\";\n }\n return x[0].approvedLogoUrl;\n}\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1169,"value":"orangeDonutUrl = await FileAttachment(\"donut-2.png\").url()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1246,"value":"blueDonutUrl = await FileAttachment(\"donut-3.png\").url()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":159,"value":"d3 = require('d3@5')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"import {vl} from '@vega/vega-lite-api-v5'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":161,"value":"import { aq, op } from '@uwdata/arquero'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W34","stdlib":"1"}} 31:"$30:body"