[Libreoffice-qa] Bugzilla User Stats

Pedro pedlino at gmail.com
Fri Feb 13 14:33:15 PST 2015

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...


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.

More information about the Libreoffice-qa mailing list