[Libreoffice-qa] Bugzilla User Stats

[Pedro]

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.