I calculate the daily active users for each of the last 7 days and add them up. So the 435,187 active users of last week is actually an average of 62,169 daily active users (435,187 divided by 7).
I tried to calculate the weekly active users, but my script to calculate this runs out of memory. It is just too much data ;-)
Maybe you should put the average into the chart instead of the sum? Adding them up doesn't make much sense to me, it means a lot of double counting. Though both average and sum will be off vs. weekly active users.
According to my database there were 122295 accounts either voting or commenting (or both) in last 14 days.
I think the sum of 7 days makes more sense, because all charts in my weekly report show a number of a 7 day period.
Yes, that's true.
In the case of other charts such as posts, votes and comments, the sum is a meaningful number. When you count users though, by summing them you double count several times (many users are active every day and get counted as 7 users).
Here's the daily average per week.
I think you're right that this gives a better representation. I'll use this one for my weekly report going forward. Thanks for contributing.
Ok, thanks for clarification on that. Does the 62,169 include just posters/commenters and voters?
Yes, an active user is an account that interacted with the Steem blockchain on that day. This can be any transaction: a vote, post, comment, transfer and so on.