<div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote">On Sat, Nov 1, 2014 at 12:17 AM, Teemu Murtola <span dir="ltr"><<a href="mailto:teemu.murtola@gmail.com" target="_blank">teemu.murtola@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div>
<div dir="ltr">Interesting graph. I assume that the number of changes is the number of new created changes. </div></div></blockquote><div>yes </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div><div dir="ltr">It might also be interesting to to include the number of changes that were resolved (merged, abandoned, deleted), and possibly the average in-flight
time (from initial upload to resolution) of a change. Not sure how easy the latter is to calculate from available data or to present in the same graph, but these could be useful to get an idea of what one can expect for new changes.<br></div></div></blockquote><div><br></div><div>The average number of days it took from a change to be created until it was merged:</div><div><br></div><div><div>select avg(m.WRITTEN_ON-c.CREATED_ON),month(m.WRITTEN_ON) as month, year(m.WRITTEN_ON) as year from changes as c, change_messages as m where c.CHANGE_ID=m.CHANGE_ID and c.STATUS='M' and m.message like 'Change has been successfully%' group by month,year order by year,month;</div><div><br></div><div> AVG(DATEDIFF('DAY', C.CREATED_ON, M.WRITTEN_ON)) | MONTH | YEAR</div><div> -------------------------------------------------+-------+-----</div><div> 1 | 8 | 2011</div><div> 2 | 9 | 2011</div><div> 14 | 10 | 2011</div><div> 9 | 11 | 2011</div><div> 15 | 12 | 2011</div><div> 6 | 1 | 2012</div><div> 14 | 2 | 2012</div><div> 4 | 3 | 2012</div><div> 3 | 4 | 2012</div><div> 3 | 5 | 2012</div><div> 7 | 6 | 2012</div><div> 10 | 7 | 2012</div><div> 4 | 8 | 2012</div><div> 6 | 9 | 2012</div><div> 11 | 10 | 2012</div><div> 7 | 11 | 2012</div><div> 11 | 12 | 2012</div><div> 7 | 1 | 2013</div><div> 10 | 2 | 2013</div><div> 19 | 3 | 2013</div><div> 28 | 4 | 2013</div><div> 17 | 5 | 2013</div><div> 29 | 6 | 2013</div><div> 18 | 7 | 2013</div><div> 34 | 8 | 2013</div><div> 25 | 9 | 2013</div><div> 28 | 10 | 2013</div><div> 30 | 11 | 2013</div><div> 7 | 12 | 2013</div><div> 21 | 1 | 2014</div><div> 20 | 2 | 2014</div><div> 15 | 3 | 2014</div><div> 6 | 4 | 2014</div><div> 9 | 5 | 2014</div><div> 6 | 6 | 2014</div><div> 9 | 7 | 2014</div><div> 11 | 8 | 2014</div><div> 14 | 9 | 2014</div><div> 14 | 10 | 2014</div></div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div><div dir="ltr">
<div class="gmail_extra"><br>
<div class="gmail_quote"><div><div class="h5">On Sat, Nov 1, 2014 at 3:33 AM, Roland Schulz <span dir="ltr">
<<a href="mailto:roland@utk.edu" target="_blank">roland@utk.edu</a>></span> wrote:<br>
</div></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div><div class="h5">
<div dir="ltr">
<div>I was curious about our monthly activity and made the below graph. Maybe someone else finds it interesting. </div>
<div>Shows is:</div>
<div>- Number of changes. Includes all projects (e.g. also regressiontests) and all statuses (e.g. draft)</div>
<div>- Number of patchsets. Also includes all. Shown on right axis.</div>
<div>- Number of comments. Excludes comments by Jenkins or the patch author. Shown on right</div>
<div><br>
</div>
<img src="cid:ii_14968fa0c0a3a528" alt="Inline image 2" width="481" height="289"><span><font color="#888888"><br>
-- <br>
<div>ORNL/UT Center for Molecular Biophysics <a href="http://cmb.ornl.gov" target="_blank">
cmb.ornl.gov</a><br>
<a href="tel:865-241-1537" value="+18652411537" target="_blank">865-241-1537</a>, ORNL PO BOX 2008 MS6309</div>
</font></span></div>
<br></div></div><span class=""><font color="#888888">
--<br>
Gromacs Developers mailing list<br>
<br>
* Please search the archive at <a href="http://www.gromacs.org/Support/Mailing_Lists/GMX-developers_List" target="_blank">
http://www.gromacs.org/Support/Mailing_Lists/GMX-developers_List</a> before posting!<br>
<br>
* Can't post? Read <a href="http://www.gromacs.org/Support/Mailing_Lists" target="_blank">
http://www.gromacs.org/Support/Mailing_Lists</a><br>
<br>
* For (un)subscribe requests visit<br>
<a href="https://maillist.sys.kth.se/mailman/listinfo/gromacs.org_gmx-developers" target="_blank">https://maillist.sys.kth.se/mailman/listinfo/gromacs.org_gmx-developers</a> or send a mail to
<a href="mailto:gmx-developers-request@gromacs.org" target="_blank">gmx-developers-request@gromacs.org</a>.<br>
</font></span></blockquote>
</div>
<br>
</div>
</div>
</div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature">ORNL/UT Center for Molecular Biophysics <a href="http://cmb.ornl.gov">cmb.ornl.gov</a><br>865-241-1537, ORNL PO BOX 2008 MS6309</div>
</div></div>