FAF stats

[Myxir]

i've updated my previous two posts with correct graphs, i've messed up proper time sorting

[Iszh]

I really wonder if you can see the e clan ladder week in there. Btw where is a new one?

[Softly]

Users with the most topic creations in general discussions

download7.png (14.87 KiB) Viewed 4497 times

And a version for those with a very wide screen:

download8.png (43.63 KiB) Viewed 4497 times

[Softly]

Highest mean views per topic created (at least 5 topics created in General Discussions):

download10.png (17.1 KiB) Viewed 4468 times

Number of topics created each month in General Discussions:

download9.png (60.17 KiB) Viewed 4468 times

EDIT speed2: reminder from the first post:

Any posts without a (proper*) graph I'll ask to be deleted.

[Softly]

The following graphs were created from a join the the game_stats and game_player_stats table using the game id.

Methodology:
- Games where no players could be found were discarded
- Even teams => At least 2 teams, and all teams have the same number of players
- Game is marked as valid => FAF thought it was a ranked game

download11.png (123.5 KiB) Viewed 4306 times

download12.png (96.16 KiB) Viewed 4306 times

download13.png (64.47 KiB) Viewed 4306 times

[tatsu]

The]

I need interpretation for all of this.

Fisrt of I'm guessing since the second and third graph don't show overall increase over time that this implies that we're talking about "games per day" or "games per week" or something.

In that case are we seeing an increase of games being played over time in the first graph?

if not are we to take it the red line in the last third of the graph is those same invalid games from the middle part but now they are just a percent subject to the increasing amount of total games and basically that means there were basically zero new ones of those after the middle part???

if yes then whats the constant decline yet persistent remainder of those indicate?

what are those two drastic changes?

in the second graph what's "only one team" ? I can't in good conscience apply that to 1 v 1 are 1 v 1's represented?

[dev_nulled]

What does 'marked valid' mean? Ranked vs something that had restrictions or mods that disable ranking?

[keyser]

*rated

[Softly]

...

I can explain what data I am showing, but interpretations of said data is an exercise left to the reader. I aim to inform, not to persuade or influence

All of the data is bucketed by week, so the first graph is "total games per week" for each of the conditions.

The second and third graph show proportions of all games and proportions of all games with even teams respectively, with each line representing various ways of cutting the games.

As some context for why I produced these graphs, I was attempting to measure the quality of the data that FAF had on games. The "validity" flag was pointed out to me as indication whether or not the game was ranked, and so I took a special interest in it. Apart from that, all I did was join the game_stats and game_player_stats tables together to reconstruct the teams as FAF understood them for each game.

I don't know the mechanics of how the team is recorded for a player, so these graphs should be seen as a "naive view". If I was to speculate on why there are games with only one team, I would point to games vs AI, coop games, and sandbox games as possible causes. 1v1s on the other hand are recorded (as far as I can tell from the data) as two teams, each with one player.

The key takeaway for me from this analysis is that the validity flag is not consistently applied to all the data in the database, but it's use has changed over time.

If one was to assume that validity => ranked, that would suggest that there were no unranked games between early 2014 and early 2016.

Since I was responding to you tatsu, I thought it would be fitting to include a graph showing our mutual (and otherwise) contacts, as determined by who we play games with:

download14.png (134.4 KiB) Viewed 4127 times

For each player I determined the top 10 people they played with. The network shown is a contact graph using "Softly", "foe" and "tatsu" as seed nodes, to a depth of 2 (seed nodes red, 1 hop nodes blue, 2 hop nodes green).

In this network, the distance between us is 3 hops.

If anyone else particularly wants to see their contact graph then let me know

[FtXCommando]

So games against AI/Campaign missions are basically like half the community. Damn, didn't expect it to be that large.