JIRA Bug统计方式说明.docx

JIRA Bug统计方式-.在JIRA查询过滤器中取得数据1. 登入JIRA2. Projects里选择项目3. 点击Issues边上的三角，在下拉菜单中选择more。选择Edit按钮，在边 上出现Query代码框。4. 输出JQL语句在搜索条内：type=Bug AND updated > "2011/06/15" AND updated < "2011/06/17"点击Search按钮后，在下面显示搜索结果。+ Create Issue3 Views Teels Syntax Help ®project = project-stomp AND type=Bug AND updated > "2011/06/15"AND updated < "2011/06/17"二.数据导出2.1从JIRA中导出数据。点击Issue界面右上角的Views,在弹出菜单中选 择Excel Current Fieldso弹出下载框，选择目录下载数据。步骤如下图循序：点击按钮JserQ<* Views 尊 Tools -d Printable| Full Content " Help O rrentUserQ xmlRSS (IssuesResolRSS (Comments;选择按钮WordExcel i Al I fields;-Excel (Currentfields)fated Due询海ChartsJun/11ned Ur-resc On Dashboard un/11根据不同浏览器各有不同三、Excel表数据操作3.1打开所下载的Excel表格IXJIRA2 |RA3 Displaying 5 issues at 17/Jun/11 3:38 PM4Issue TypeKeySummaryAssigneeReporterPriorityStatusResolutionCreatedUpdatedDue Date5BugSTOP_*Poe The text on the buttons which are on the page after clicking Contribute here is erroralex xin lusun.shiTrivialOpenUnresolved16/Jun/11 10 57 AM16/Jun/11 10 57 AM6BugSTOW-29Poe The space between the buttons which are on the page after clicking Contribute here is a little largerpoe xingming caisun.shiTrivialReopenedUnresolved13/Jun/11 9 19 PM16/Jun/11 9:59 AM7BugSTOXP-27The name of "Shoot a photo/video" is errorpoe xingming caisun.shiTrivialClosedFixed13/Jun/11 9 11 PM16/Jun/11 10 00 AM8BugSTON-23Fixedbruce dezhi lisun.shiMajorClosedFixed13/Jun/11 8 56 PM16/Jun/11 10 22 AM9BugSTOW-21OKbruce dezhi lisun shiMajorClosedFixed13/Jun/11 8 45 PM16/Jun/11 1041 AM10 Generated st Fri Jun 17 15:38:32 CST 2011 by sun.shi using JIRA 4 2.4-b531*5913.2建立数据透视图。随便选择表格中一个单元格，在插入中选择数据透视表弹出界面如下图:默认区域为原有表格，请检出，如不是则选择需要数据段的表格范围。345578%L01112L3L4L5数据透视表1若要生成报表，请从，数据透视表字段列表”中选择字段。16L8_1910确认后出现上图3.3取得所需求数据1.按优先级统计个Issue状态的数量。将Priority拖动全行标签框，Status拖入类标签框，将Issue Type托入数 值框中。再左边得到新的表：计数项:l55ueType标签十行标签十 CloBed Open Reopened 总计Major22Trivial1 113总计3115保存新表数据，如有需求则进行二次数据操作。2.按开发人员统计完成Resolve的数量将Assignee拖动全行标签框（在拖动前可在个字段的下拉菜单中按需求选 择人员），将Resolved （同样可选择Resolved的子项）拖动至列标签，将Issue Type拖动全数值框，得新表：许杰项:1皿eTy煦例标签工行标签总计&ruce dezhi li22ooe xingming cai11iI3 .统计QA creat与close bug的数量将Reporter拖动全行标签，将Issue Type拖动至列标签，将key拖动全数 值框，左边的到QA Creat Issue数量表：计数项:I55UeType I列标签行标签总计sun.shi55总计55将Reporter拖动全行标签，将Status拖动至列标签（status中只选择 closed状态），将key拖动全数值框，左边的到QA Closed Issue数量表：汗费项：15海Type 列标签“ 芹粽囊-'chsed 总计iun.shi总计最后将得到的数据进行汇总。