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
