Here is the monthly defect in/out data: Date Opened Fixed 2011-06-01 0 0 2011-07-01 93 23 2011-08-01 207 25 2011-09-01 265 28 2011-10-01 289 34 2011-11-01 344 55 2011-12-01 415 77 2012-01-01 462 101 2012-02-01 598 153 2012-03-01 711 190 2012-04-01 844 233 2012-05-01 963 250 2012-06-01 1250 287 2012-07-01 1677 425 2012-08-01 1903 512 2012-09-01 2161 597 2012-10-01 2444 718 2012-11-01 2576 756
2012/11/6 Shenfeng Liu <liush...@gmail.com> > Yan Ji, > Good question! > Originally, I only created the 2 queries that included every thing, so > that not only the product defects, but also QA activities, translation > tasks, web enhancement efforts were all included. > > While I'm also thinking that we can create more specific charts, e.g. the > product defects (as you mentioned), feature/enhancement, and patches > waiting for review, resolved defects waiting for verifying, progress on our > automation test case development... > > Let's work together on it. > > - Shenfeng (Simon) > > > 2012/11/6 Ji Yan <yanji...@gmail.com> > > > Simon, > > I have question about your query, why not exclude criteria > > issue_type=task and issue_type=patch, and also exclude product= qa. I > find > > most defects in qa product are intend to check-in automation scripts. > > > > Use this query [1], I got 2444 defects opened from 2011/06 to 2012/09. > > Use this query [2], I got 718 defects fixed from 2011/06 to 2012/09 > > > > > > [1] > > > > > https://issues.apache.org/ooo/buglist.cgi?v4=Duplicate&o5=notequals&f1=cf_bug_type&o3=notequals&v6=20110601&o7=lessthan&list_id=37797&v3=qa&o1=notequals&o2=notequals&o6=greaterthaneq&v7=20121001&f4=resolution&v5=Invalid&query_format=advanced&f3=product&f2=cf_bug_type&o4=notequals&f5=resolution&v1=Patch&f6=creation_ts&v2=Task&f7=creation_ts > > > > [2] > > > > > https://issues.apache.org/ooo/buglist.cgi?o5=equals&f1=cf_bug_type&o7=changedbefore&v6=20110601&o3=notequals&list_id=37799&f8=CP&v3=qa&o1=notequals&resolution=FIXED&o6=changedafter&o2=notequals&v7=20121001&f4=OP&v5=Fixed&query_format=advanced&f3=product&f2=cf_bug_type&f5=resolution&v1=Patch&f6=resolution&v2=Task&f7=resolution&; > > > > > > > > 2012/11/2 Shenfeng Liu <liush...@gmail.com> > > > > > Yan Ji, > > > I used the following 2 queries: > > > > > > All_Reported_Since - > > > > > > > > > https://issues.apache.org/ooo/buglist.cgi?cmdtype=dorem&remaction=run&namedcmd=All_Reported_Since&sharer_id=249089 > > > All_Fixed_Since - > > > > > > > > > https://issues.apache.org/ooo/buglist.cgi?cmdtype=dorem&remaction=run&namedcmd=All_Fixed_Since&sharer_id=249089 > > > > > > The start date was set to 2011-06-01. While you need to edit the > > queries > > > and set the end date to 2012-09-01, 2012-10-01, 2012-11-01. Then input > > the > > > data to defects.txt . > > > Please help to update the chart. And tell me if any question. Thanks! > > > > > > - Shenfeng Liu (Simon) > > > > > > > > > > > > 2012/11/1 Ji Yan <yanji...@gmail.com> > > > > > > > Thanks, I'll talk to Simon for the detail data. > > > > > > > > 2012/11/1 Rob Weir <robw...@apache.org> > > > > > > > > > On Mon, Oct 29, 2012 at 9:23 PM, Ji Yan <yanji...@gmail.com> > wrote: > > > > > > Hi Rob, > > > > > > Sure I can update this chart in my weekly report, please let me > > > know > > > > > how > > > > > > to do. > > > > > > 1. Where should I upload the data to > > > > > > 2. What the numbers mean, e.g. 2012-08-01,2316,1208, does this > mean > > > in > > > > > 2012 > > > > > > Aug, 2316 defects opened and 1208 fixed? > > > > > > > > > > > > > > > > Shenfeng Liu created the original data file. I don't know how he > got > > > > > the data. Maybe you can ask him. > > > > > > > > > > If you post an update to the list (or the ooo-qa) list I can add to > > > > > website for you. > > > > > > > > > > We can also add some text to that page to explain what the numbers > > > mean. > > > > > > > > > > -Rob > > > > > > > > > > > > > > > > 2012/10/29 Rob Weir <robw...@apache.org> > > > > > > > > > > > >> On Mon, Oct 29, 2012 at 8:20 AM, Ji Yan <yanji...@gmail.com> > > wrote: > > > > > >> > Please find weekly defect analysis report > > > > > >> > > http://wiki.openoffice.org/wiki/QA/Report/DefectStatus/20121029 > > > > > >> > > > > > > >> > > > > > >> > > > > > >> Thanks for the report. > > > > > >> > > > > > >> Would it be possible to also get an update for this chart: > > > > > >> http://www.openoffice.org/stats/defects.html ??? > > > > > >> > > > > > >> The data file is here: > > http://www.openoffice.org/stats/defects.txt > > > > > >> > > > > > >> Can I get the right numbers from that report? > > > > > >> > > > > > >> -Rob > > > > > >> > > > > > >> > -- > > > > > >> > > > > > > >> > > > > > > >> > Thanks & Best Regards, Yan Ji > > > > > >> > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > > > > > > > > > > > > Thanks & Best Regards, Yan Ji > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > > > > > > Thanks & Best Regards, Yan Ji > > > > > > > > > > > > > > > -- > > > > > > Thanks & Best Regards, Yan Ji > > > -- Thanks & Best Regards, Yan Ji
