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: [email protected] 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/
