-
Notifications
You must be signed in to change notification settings - Fork 1.8k
Description
版本号:1.5.2
问题描述:图表配置SQL数据集,点击运行报错
1、SQL数据集,数据预览是有数据的
2、选择图表并配置该数据源
点击运行后出现下图错误
错误日志&截图:
重现步骤:
如上。
报表SQL:
SELECT t.sDate ,t.energy_id ,t.energy_name ,t.num ,t.cost FROM (
select '2022-03' as sDate, 354538254603264 as energy_id, '消防水' as energy_name, 24.00 as num, 26.00 as cost
union
select '2022-03' as sDate, 354538328798208 as energy_id, '自来水' as energy_name, 20.00 as num, 22.00 as cost
union
select '2022-03' as sDate, 354721364814848 as energy_id, '风电 ' as energy_name, 12.00 as num, 13.00 as cost
union
select '2022-04' as sDate, 354538254603264 as energy_id, '消防水' as energy_name, 24.00 as num, 26.00 as cost
union
select '2022-04' as sDate, 354538328798208 as energy_id, '自来水' as energy_name, 20.00 as num, 22.00 as cost
union
select '2022-04' as sDate, 354721364814848 as energy_id, '风电 ' as energy_name, 12.00 as num, 13.00 as cost
union
select '2022-05' as sDate, 354538254603264 as energy_id, '消防水' as energy_name, 21.00 as num, 55.11 as cost
union
select '2022-06' as sDate, 354538254603264 as energy_id, '消防水' as energy_name, 67.00 as num, 71.00 as cost
) t
WHERE t.sDate BETWEEN DATE_FORMAT(DATE_SUB('${statisticsDate}-01', INTERVAL 11 MONTH), '%Y-%m')
AND '${statisticsDate}'
参数statisticsDate 默认上月 =dateStr('yyyy-MM', -1)
友情提示(为了提高issue处理效率):
- 积木报表是一款免费报表产品,功能免费源码不开放;
- 未按格式要求发帖,会被直接删掉;
- 请针对问题提供报表设计SQL脚本或在官网制作报表示例并提供ID;
- 针对不好重现的问题,请录制操作视频或详细的重现步骤;
Activity
lvdandan16 commentedon Sep 2, 2022
收录 ws
1298191366 commentedon Oct 18, 2022
已修复,待新版本发布