Version: 3.8.2
分析扩展开发示例
根据作业组属性统计不良率
需求
根据作业组属性检测结果的值分析出检测总数、不良数、不良率
需求明细
- 可用维度：时间、组织单元、人员、作业组
- 维度来源：默认
- 抽取作业组：全部
检测结果不良ID：b53c356c-f525-44a7-b675-fdb5d664bfd5- 子KPI：
检测总数、不良数、不良率 - 计算公式：不良率 = 不良数 / 检测总数
config.json配置
{
"ID": "d52ee1d4-84ef-4be2-a23c-bb79c7833d41",
"Port": 9033,
"Dims": [{
"Name": "时间",
"From": {
"Type": 0,
"Name": ""
}
},
{
"Name": "组织单元",
"From": {
"Type": 0,
"Name": ""
}
},
{
"Name": "人员",
"From": {
"Type": 0,
"Name": ""
}
},
{
"Name": "作业组",
"From": {
"Type": 0,
"Name": ""
}
}
],
"TaskGroupIDs": "",
"TableName": "H_Ext_Check",
"Etl": [{
"Type": 1,
"Description": {
"ID": "",
"Name": "检测结果",
"ColName": "Check_Result"
}
}],
"KPIList": [{
"KPIID": "Sum",
"KPIName": "检测总数",
"Unit": "次",
"Init": 0,
"CalculateType": 0,
"Numerator": {
"ColName": "Check_Result",
"Type": 1,
"IsCondition": false,
"Operator": "",
"Condition": ""
},
"Denominator": {
"IsCondition": false,
"Condition": "",
"Operator": "",
"ColName": "",
"Type": 0
}
},
{
"KPIID": "Fail_Num",
"KPIName": "不良数",
"Unit": "次",
"Init": 0,
"CalculateType": 0,
"Numerator": {
"ColName": "Check_Result",
"Type": 1,
"IsCondition": true,
"Operator": "=",
"Condition": "b53c356c-f525-44a7-b675-fdb5d664bfd5"
},
"Denominator": {
"IsCondition": false,
"Condition": "",
"Operator": "",
"ColName": "",
"Type": 0
}
},
{
"KPIID": "Fail_Rate",
"KPIName": "不良率",
"Unit": "%",
"Init": 0,
"CalculateType": 1,
"Numerator": {
"ColName": "Check_Result",
"Type": 1,
"IsCondition": true,
"Operator": "=",
"Condition": "b53c356c-f525-44a7-b675-fdb5d664bfd5"
},
"Denominator": {
"ColName": "Check_Result",
"Type": 1,
"IsCondition": false,
"Operator": "",
"Condition": ""
}
}
]
}
效果图
