Re: [Libreoffice-qa] Bugzilla User Stats
Robinson Tryon wrote 17,892 total user accounts in Bugzilla, comprising 536 users who have successfully migrated from FDO, 17,002 who haven't, and 354 new accounts. So, in total 890 registered users (pretty good!) Robinson Tryon wrote In terms of activity, we've had 448 users active in the last week, and 1304 active in the last month. More active users than registered??? -- View this message in context: http://nabble.documentfoundation.org/Libreoffice-qa-Bugzilla-User-Stats-tp4139920p4139978.html Sent from the QA mailing list archive at Nabble.com. ___ List Name: Libreoffice-qa mailing list Mail address: Libreoffice-qa@lists.freedesktop.org Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://lists.freedesktop.org/archives/libreoffice-qa/
Re: [Libreoffice-qa] Bugzilla User Stats
Robinson Tryon wrote All the queries I used I put here. Any Postgres/Bugzila wizards have some suggestions? :-) https://wiki.documentfoundation.org/QA/Bugzilla/Administration#User_Statistics I'm not sure but if that is a daily register of last_seen, when you count last_seen for the last 7 days, the same user will be accounted 7 times if he logged all the 7 days... This is probably not noticeable in 7 days but it escalates when you sum 30 days... I'm not an SQL wizard but you probably want the max last_seen for each user in the given period... Cheers, Pedro -- View this message in context: http://nabble.documentfoundation.org/Libreoffice-qa-Bugzilla-User-Stats-tp4139920p4140064.html Sent from the QA mailing list archive at Nabble.com. ___ List Name: Libreoffice-qa mailing list Mail address: Libreoffice-qa@lists.freedesktop.org Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://lists.freedesktop.org/archives/libreoffice-qa/
[Libreoffice-qa] Bugzilla User Stats
Hi all, From the ESC call this morning: * QA (Robinson) + how many people have migrated from the fdo (updated their accounts)? (Bjoern) + will try to find the number (Robinson) Results: We have 17,892 total user accounts in Bugzilla, comprising 536 users who have successfully migrated from FDO, 17,002 who haven't, and 354 new accounts. In terms of activity, we've had 448 users active in the last week, and 1304 active in the last month. Cheers, --R -- Robinson Tryon QA Engineer - The Document Foundation LibreOffice Community Outreach Herald qu...@libreoffice.org ___ List Name: Libreoffice-qa mailing list Mail address: Libreoffice-qa@lists.freedesktop.org Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://lists.freedesktop.org/archives/libreoffice-qa/