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 >
