基本上我有一个训练数据集,但我希望它显示为零,而不是根本不显示
下面的节目都是不完整和完整的,但我希望它显示不完整和从部门有零不完整为0
这是我到目前为止所拥有的,我需要它来展示一切,我的同事试图帮助我,但不得不离开,所以我请你们
Select distinct Department, Total FROM
(
Select Department, Total FROM
(
SELECT 'Incomplete' AS Status, department, count(*) as Total
FROM MyTable
WHERE CompletedTraining = 'Incomplete'
GROUP BY department
union all
Select 'Complete' AS Status, department, Count(*) as Total
FROM MyTable
WHERE CompletedTraining = ' Complete'
Group By Department
)
WHERE Status = 'Incomplete'
)
union all
SELECT DISTINCT Department, NULL AS Total
FROM MyTable
当我运行python脚本时
Incomplete Training
[6, 8, 2, 3, 6, 4, 4, 5, 2, 4]
但如果有人接受了我的训练,我希望在名单上显示为零 所以我的预期输出是这样的
Incomplete Training
[6, 8, 2, 3, 6, 4, 4, 5, 2, 4, 0, 0]
示例文档X 1500行,包含多个用户
Curriculum Name Department Employee Name Employee Email Employee Status Date Assigned Completion Date CompletedTraining
Security Training OIS John Doe john.doe@email.org Active 7/18/2017 21:47 8/2/2017 21:31 Complete
Support Training OIS Home Simpson home.simpson@email.gov Active 4/20/2017 15:33 5/3/2017 22:18 Complete
Security Training ASD bart simpson bart.simpson@email.gove Active 5/5/2017 20:22 11/30/2017 19:43 incomplete
Security Training CO jack johnson jack.johnson@email.gov Active 5/9/2017 21:15 5/10/2017 20:23 incomplete
Security Training ECARS jack johnson jack.johnson@email.gov Active 5/9/2017 21:15 5/10/2017 20:23 incomplete
Security Training EO jack johnson jack.johnson@email.gov Active 5/9/2017 21:15 5/10/2017 20:23 incomplete
Security Training ISD jack johnson jack.johnson@email.gov Active 5/9/2017 21:15 5/10/2017 20:23 incomplete
Security Training MSCD jack johnson jack.johnson@email.gov Active 5/9/2017 21:15 5/10/2017 20:23 incomplete
Security Training RD jack johnson jack.johnson@email.gov Active 5/9/2017 21:15 5/10/2017 20:23 incomplete
Security Training TTD jack johnson jack.johnson@email.gov Active 5/9/2017 21:15 5/10/2017 20:23 incomplete
Security Training DP jack johnson jack.johnson@email.gov Active 5/9/2017 21:15 5/10/2017 20:23 incomplete
Security Training MLD jack johnson jack.johnson@email.gov Active 5/9/2017 21:15 5/10/2017 20:23 incomplete
Security Training OIS jack johnson jack.johnson@email.gov Active 5/9/2017 21:15 5/10/2017 20:23 incomplete
Security Training TTD jack johnson jack.johnson@email.gov Active 5/9/2017 21:15 5/10/2017 20:23 incomplete
Security Training TTD jack johnson jack.johnson@email.gov Active 5/9/2017 21:15 5/10/2017 20:23 incomplete
Security Training AQPSD jack johnson jack.johnson@email.gov Active 5/9/2017 21:15 5/10/2017 20:23 incomplete
这会让你得到不完整的#
在同一行上完成
或者类似的
相关问题 更多 >
编程相关推荐