问题描述:
在仪表板中使用“透视表”组件,发现当预览时,透视表的数据加载过慢,有时候甚至加载不出来
问题截图:
部分计算列:
分包合同大类:
SWITCH(
'分包合同移交分发'[SUB_SINOMAEE_CONTRACT_TYPE],
"Domestic Process Equipment Contract","设备材料采购合同",
"Domestic Electrical Automation Equipment Contract","设备材料采购合同",
"Domestic Material Contract","设备材料采购合同",
"Re Export Process Equipment Contract","设备材料采购合同",
"Transit Electrical Automation Equipment","设备材料采购合同",
"Local Procurement Contract","设备材料采购合同",
"Other Procurement Contracts","设备材料采购合同",
"Construction Contract","专业分包合同",
"Civil Construction Contract","专业分包合同",
"Steel Structure Grid Procurement Contract","专业分包合同",
"Steel Structure Grid Installation Contract","专业分包合同",
"Steel Structure Grid Procurement And Installation Contract","专业分包合同",
"Installation Contract","专业分包合同",
"Domestic Design Contract","专业分包合同",
"Foreign Design Contract","专业分包合同",
"Technical Service Contract","服务合同",
"Training Contract","服务合同",
"Commissioning Contract","服务合同",
"Service Contract","服务合同",
"Logistics Contract","服务合同",
"Insurance Contract","服务合同",
"Foreign Management Contract","服务合同",
"其他类型合同"
)
分包合同-小类
SWITCH(
'分包合同移交分发'[SUB_SINOMAEE_CONTRACT_TYPE],
"Construction Contract","施工合同",
"Civil Construction Contract","土建施工合同",
"Steel Structure Grid Procurement Contract","钢结构/网架采购合同",
"Steel Structure Grid Installation Contract","钢结构/网架安装合同",
"Steel Structure Grid Procurement And Installation Contract","钢结构/网架采购安装合同",
"Installation Contract","安装合同",
"Domestic Process Equipment Contract","国产工艺设备合同",
"Domestic Electrical Automation Equipment Contract","国产电气自动化设备合同",
"Domestic Material Contract","国产材料合同",
"Re Export Process Equipment Contract","转口工艺设备合同",
"Transit Electrical Automation Equipment","转口电气自动化设备",
"Local Procurement Contract","当地采购合同",
"Other Procurement Contracts","其他采购合同",
"Domestic Design Contract","国内设计合同",
"Foreign Design Contract","国外设计合同",
"Technical Service Contract","技术服务合同",
"Training Contract","培训合同",
"Commissioning Contract","调试合同",
"Service Contract","服务合同",
"Logistics Contract","物流合同",
"Insurance Contract","保险合同",
"Foreign Management Contract","国外管理合同",
null,"其他类型合同",
'分包合同移交分发'[SUB_SINOMAEE_CONTRACT_TYPE]
)
是否和“度量值公式”和“计算列”逻辑比较复杂有关系?
|