jira数据查询(按周统计线上bug,所有bug,bug占比)
来源:互联网 发布:mac steam 联机游戏 编辑:程序博客网 时间:2024/05/18 16:39
SELECT IFNULL(c1,'total') AS 项目名称,
SUM(IF(c2='20',C3,0)) AS 第20周线上,
SUM(IF(c2='20',C4,0)) AS 第20周所有,
CONCAT(LEFT(IF(SUM(IF(c2='20',C3,0))=0,0,SUM(IF(c2='20',C3,0)) /SUM(IF(c2='20',C4,0)) )*100 ,6),'%') AS 漏出占比,
SUM(IF(c2='21',C3,0)) AS 第21周线上,
SUM(IF(c2='21',C4,0)) AS 第21周所有,
CONCAT(LEFT(IF(SUM(IF(c2='21',C3,0))=0,0,SUM(IF(c2='21',C3,0)) /SUM(IF(c2='21',C4,0)) )*100 ,6),'%') AS 漏出占比,
SUM(IF(c2='22',C3,0)) AS 第22周线上,
SUM(IF(c2='22',C4,0)) AS 第22周所有,
CONCAT(LEFT(IF(SUM(IF(c2='22',C3,0))=0,0,SUM(IF(c2='22',C3,0)) /SUM(IF(c2='22',C4,0)) )*100 ,6),'%') AS 漏出占比,
SUM(IF(c2='23',C3,0)) AS 第23周线上,
SUM(IF(c2='23',C4,0)) AS 第23周所有,
CONCAT(LEFT(IF(SUM(IF(c2='23',C3,0))=0,0,SUM(IF(c2='23',C3,0)) /SUM(IF(c2='23',C4,0)) )*100 ,6),'%') AS 漏出占比,
SUM(IF(c2='24',C3,0)) AS 第24周线上,
SUM(IF(c2='24',C4,0)) AS 第24周所有,
CONCAT(LEFT(IF(SUM(IF(c2='24',C3,0))=0,0,SUM(IF(c2='24',C3,0)) /SUM(IF(c2='24',C4,0)) )*100 ,6),'%') AS 漏出占比
#concat(left(if(SUM(IF(c2='2',C3,0))=0,0,SUM(IF(c2='2',C3,0)) /SUM(IF(c2='2',C4,0)) )*100 ,6),'%') AS 漏出占比
#SUM(C3) AS 漏出总数,
#SUM(C4) AS 总数
FROM ( SELECT t1.c1,t1.c2,t1.c3,t2.c4 FROM
(SELECT b.pname AS c1,WEEK(a.created)+1 AS c2,COUNT(a.id) AS c3 FROM jiraissue a
LEFT JOIN project b ON a.project=b.id
LEFT JOIN issuetype c ON a.issuetype=c.id
WHERE a.created>='2014-1-1 00:00:00' AND a.issuetype=27 AND issuestatus NOT IN (10028,10029)
GROUP BY c1,c2) t1
LEFT JOIN
(SELECT b.pname AS c1,WEEK(a.created)+1 AS c2,COUNT(a.id) AS c4 FROM jiraissue a
LEFT JOIN project b ON a.project=b.id
LEFT JOIN issuetype c ON a.issuetype=c.id
WHERE a.created>='2014-1-1 00:00:00' AND a.issuetype IN(27,28) AND issuestatus NOT IN (10028,10029)
GROUP BY c1,c2)t2 ON t1.c1=t2.c1 AND t1.c2=t2.c2
GROUP BY t1.c1,t1.c2
)tx
GROUP BY C1 WITH ROLLUP ;
0 0
- jira数据查询(按周统计线上bug,所有bug,bug占比)
- JIRA如何统计重新打开的BUG及BUG数
- JIRA bug管理系统配置
- JIRA BUG跟踪系统
- HttpClient线上bug
- beanshell 线上修复BUG
- ios 定位线上bug
- iOS线上修复bug
- 记录一则线上bug
- 关于线上bug
- 线上bug记录
- bug
- Bug
- BUG
- bug
- bug
- BUG?
- bug
- HowTo: ListView, Adapter, getView and different list items’ layouts in one ListView
- session & cookie
- 第二章 2.1.2节练习
- EPoll模型
- 建立Android 遇到gen文件错误 无法编译的问题
- jira数据查询(按周统计线上bug,所有bug,bug占比)
- 有关equals()的小例子
- 主机使用代理上网,虚拟机Linux的shell如何连外网
- Objective-C语法之代码块(block)的使用,回调函数
- Nginx配置文件nginx.conf中文详解(总结)
- JAVA调用 TSC 打印机 打印中文问题/JNA中文乱码
- 运算符“/”和“%”的学习记录
- GetComponentsInChildren Not Work In OnDisable[Unity]
- 二叉树的下一个结点