QA/Data harvesting/Progress Card: Difference between revisions

From MozillaWiki
Jump to navigation Jump to search
Line 28: Line 28:
| [mailto:mkurze@mozilla.com Michael Kurze]<br>  
| [mailto:mkurze@mozilla.com Michael Kurze]<br>  
|  
|  
This will need flags to allow for better selection of releases.
This will need flags to allow for better selection of releases.
Also, DWH data is incomplete (only bugs #560K to about #585K are included).


Solr queries (without flags)
* opened/found per week (last 7 weeks): [http://cm-metricsetl05:8983/solr/select/?q=previous_status:%3Cnone%3E&facet=true&facet.date=modification_date&facet.date.gap=%2B7DAY&facet.date.start=NOW-49DAY/DAY&facet.date.end=NOW/DAY&indent=on&rows=0]
 
* opened/found over time: [http://cm-metricsetl05:8983/solr/select/?q=previous_status:%3Cnone%3E&facet=true&facet.date=modification_date&facet.date.gap=%2B7DAY&facet.date.start=NOW-49DAY/DAY&facet.date.end=NOW/DAY&indent=on&rows=0]


* closed/fixed over time: [http://cm-metricsetl05:8983/solr/select/?q=expiration_date:%5BNOW+TO+*%5D%20major_status:CLOSED&facet=true&facet.date=modification_date&facet.date.gap=%2B7DAY&facet.date.start=NOW-49DAY/DAY&facet.date.end=NOW/DAY&indent=on&rows=0 closed/fixed]
* closed/fixed over time (last 7 weeks): [http://cm-metricsetl05:8983/solr/select/?q=expiration_date:%5BNOW+TO+*%5D%20major_status:CLOSED&facet=true&facet.date=modification_date&facet.date.gap=%2B7DAY&facet.date.start=NOW-49DAY/DAY&facet.date.end=NOW/DAY&indent=on&rows=0]


<br>  
<br>  
Line 85: Line 85:
|
|
   
   
Current open bugs by component, for products Firefox and Core: [http://cm-metricsetl05.mozilla.org:8983/solr/select/?q=expiration_date:%5BNOW+TO+*%5D%20major_status:OPEN%20%28product:Firefox%20OR%20product:Core%29&facet=true&facet.field=component&rows=0]
* Current open bugs by component, for products Firefox and Core: [http://cm-metricsetl05.mozilla.org:8983/solr/select/?q=expiration_date:%5BNOW+TO+*%5D%20major_status:OPEN%20%28product:Firefox%20OR%20product:Core%29&facet=true&facet.field=component&rows=0]


Same, but only the 10 components with the most bugs: [http://cm-metricsetl05.mozilla.org:8983/solr/select/?q=expiration_date:%5BNOW+TO+*%5D%20major_status:OPEN%20%28product:Firefox%20OR%20product:Core%29&facet=true&facet.field=component&facet.limit=10&rows=0]
* Same, but only the 10 components with the most bugs: [http://cm-metricsetl05.mozilla.org:8983/solr/select/?q=expiration_date:%5BNOW+TO+*%5D%20major_status:OPEN%20%28product:Firefox%20OR%20product:Core%29&facet=true&facet.field=component&facet.limit=10&rows=0]





Revision as of 18:05, 31 August 2010

Progress Card



Feature Prio Status Estimated Date of Completion Owner
Additional Comments

Find/fixed Rate-trend Graphs

Sample metrics types here

P1


2010-08-27


Michael Kurze

This will need flags to allow for better selection of releases. Also, DWH data is incomplete (only bugs #560K to about #585K are included).

  • opened/found per week (last 7 weeks): [1]
  • closed/fixed over time (last 7 weeks): [2]


Buckets:grouped by priority

Samples from bugzilla here.

P1




  • Current open bugs by prio for products Firefox and Core: prio


Buckets:grouped by severity

P1




  • Currently open bugs by severity, for products Firefox and Core: [3]


Buckets:grouped by   component

Sample from bugzilla here

P1




  • Current open bugs by component, for products Firefox and Core: [4]
  • Same, but only the 10 components with the most bugs: [5]



Buckets:grouped by bug-asignee

Sample metrics types here

P3




Can be done with current DW data


Buckets:grouped by flags

Sample metrics types here

P1


2010-08-20


Michael Kurze
Needs flags

Ability to compare data from different releases

Sample from bugzilla here


P1


2010-08-27


Michael Kurze
Needs flags

What data (everything listed in the other features?)

Answer: Ideally,we should be able to trim the data we want to compare based on target milestone,component,keywords,flags etc

https://bugzilla.mozilla.org/query.cgi

Ability to compare data from different projects

Sample from bugzilla here

P2




Can be done with current DW data (?)

is Product/Component sufficient for this? Please add other fields that can indicate a project (flags? keywords?)

Answer: Ideally,we should be able to trim the data we want to compare based on target milestone,component,keywords,flags etc

https://bugzilla.mozilla.org/query.cgi

Tabular reporting

P3

CURRENTLY AVAILABLE


NA



The metrics dashboard should automatically deliver this with all dashboard items.


Average age of a bug in each component

Sample metric types here

P1




Can be done with current DW data


Rate/percentage of bugs being reopened/project

Sample metric types here

P2




Can be done with current DW data (?)

how are projects identified (see above)

Regression bugs per release/project

Samples from bugzilla here

P1


2010-09-04


Michael Kurze
Needs keywords and flags



Average age of bugs in unconfirmed status

Sample metrics types here

P1





Can be done with current DW data

Options to-CSV/JSON/Save the graph as an image

P3

CURRENTLY AVAILABLE


NA



If anything of this is buggy or difficult, it is probably best to file a metrics bug.