为什么悬浮图表的数据出不来?但在数据集里给出参数值就可以显示图表,去掉参数值后就没有数据出来,这是为什么? 这是数据集语句 SELECT a.inviter as '邀约人', a.inviter_count AS '邀约人数', a.participate_count AS '到面人数', CASE WHEN a.inviter_count = 0 THEN 0 ELSE a.participate_count / a.inviter_count END AS '到面率', a.result_count AS '通过人数', CASE WHEN a.participate_count = 0 THEN 0 ELSE a.result_count / a.participate_count END AS '通过率', a.employment_count AS '入职人数', CASE WHEN a.result_count = 0 THEN 0 ELSE a.employment_count / a.result_count END AS '入职率' FROM( SELECT inviter, COUNT(*) AS inviter_count, SUM(CASE WHEN participate = '是' THEN 1 ELSE 0 END) AS participate_count, SUM(CASE WHEN result = '通过' THEN 1 ELSE 0 END) AS result_count, SUM(CASE WHEN employment = '是' THEN 1 ELSE 0 END) AS employment_count FROM dy_zp_information_entry WHERE in_date = '${days}' ${if(len(inviter) == 0,"","AND inviter = '" + inviter + "'")} GROUP BY inviter ) a 这是图表的数据字段 这是页面预览 |