Open meneal opened 9 years ago
You can get the user and how many issues they "opened" (were associated with the first event on an issue) with
select user, count(*) from event e1 where time <= (select min(time) from event where issueID = e1.issueID) group by user;
Pie plot works well for this.
This seems pretty useful since we're looking at group five at well above all of the rest, but it is only a two person group. Group 8 and 3 have users that we're almost above 50 percent.
On Wed, Apr 22, 2015 at 2:13 PM, Will Morrow notifications@github.com wrote:
Pie plot works well for this. [image: pieplot_issues_created] https://cloud.githubusercontent.com/assets/6590396/7281789/c8fc21a0-e8f9-11e4-87ca-823fe0ae7b8a.png
— Reply to this email directly or view it on GitHub https://github.com/CSC510-2015-Axitron/project2/issues/8#issuecomment-95288921 .
By this I mean it's not a great thing if only one user posts 90 percent of the issues. If that's the case it also represents disengagement in the way I was thinking with my other issue.