字段是个字符串所以没有,我这边做计算列了。
问下这个问题:distinctCount(col['project_id'] and col['construct_status_name'] != "验收" )
预览就报错了,配置的时候是好的
下面是报错:
执行数据失败:java.lang.Exception: Related Dashboard: '生产进度20230209152804-495' Related Query: '项目进度基本信息' Related Element: '数据-未编制总计划项目' Run user: '企业BI管理员808037521895198720'
Caused by: java.sql.SQLException 执行SQL失败:“Operand 'project_id AND ((construct_status_name = '在建') OR (construct_status_name = '完工'))' part of predicate 'project_id' should return type 'BOOLEAN' but returns type 'bigint(20)'.”