I am using the log file that was provided in the announcement post https://cdn.sc07.company/canvas/2023/pixels.log.txt

There aren’t any of these stats in the file, so we have to find them ourselves.

So basically I am only looking at rows that are “user placed” (which doesn’t remove the undos completely, but it’s easier to do this) then I find an instance I want to look at and only grab logs from that. I then count each uniqe user and that’s the user count for that instance. Then I divide Total Pixels by User Count to see how many pixels on average are placed by those users.

cat pixels.log.txt | grep "place" | awk '{print $3}' | awk -F"@" '{print $1" " $2" "}' | sort | uniq -c | sort -nr | grep "mander.xyz" | count

> 10

So this says there are 10 users who are from mander.xyz who have placed at least one pixel on the canvas.

cat pixels.log.txt | grep "place" | awk '{print $3}' | awk -F"@" '{print $1" " $2" "}' | grep "mander.xyz" | count

> 5896

This tells me that there are 5896 pixels that were placed by users from mander.xyz

5896/10 ~= 590

Therefore on average a user from mander.xyz placed 590 pixels on the canvas. (This is very high, you brought the average up really high with your pixel count)

I’m very tired and am having some trouble with math atm, but I hope this explanation makes sense!