https://bugzilla.wikimedia.org/show_bug.cgi?id=58196
--- Comment #46 from Eran Roz <[email protected]> --- Hi Luis, thanks for the update. (In reply to Krinkle from comment #40) > > To avoid strange statistical variance like that, I'd recommend making > timestamp of the currently running month appear as last month's. That way no > data is excluded. This seems like a simple enough variance that tools should > be able to work with without much hassle. I think it is good solution. The timestamp is used mainly for filtering active vs non-active users. (In reply to Luis Villa (WMF Legal) from comment #42) > (In reply to Tisza Gergő from comment #35) > > Maybe instead of a live view, this table could be generated by a query which > > runs at the end of the day; that way no information is leaked by the timing > > of the change. Although that still does not solve the issue for small wikis > > since we probably want to run it more often than once a month. > > If we only provide one month granularity in the answer, then it can be run > only once a month, right? Sounds like the use cases here don't need > precise/fine-grained answers to this question? *My use case: the user_properties_anonym table is used for generating[[meta:Gadgets]] - statistics on the most popular gadgets accross Wikimedia projects. * (other example for use case) User preferences statistics are provided by MZMcBride in [[en:Wikipedia:Database reports/User preferences]] So I belive one month resolution is fine for statistics use cases, and running it once a month could be enougth. As Krinkle wrote above, month resolution (YYYY-MM) make it hard to associate it to specific user. However for very very small wikis I think it isn't possible to provide such statistics: refering to http://stats.wikimedia.org/EN/TablesWikipediansEditsGt5.htm (Wikipedias by active users) some languages such as Tsonga or Oromo have only one active user. I think there should be a threshold on the number of active users in a wiki. -- You are receiving this mail because: You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
