QA/Data harvesting/Progress Card: Difference between revisions

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]




48

edits