dataease:2.10.5
mysql:8.2.0
在数据集中 ，新建数据集：新建计算字段，数据类型为维度， 参考下边截图
SELECT
[供应类型],
[出库地点],
CASE
WHEN [订单_出库时间] <= 1 THEN ‘0-1天’
WHEN [订单_出库时间] <= 3 THEN ‘1-3天’
WHEN [订单_出库时间] <= 5 THEN ‘3-5天’
WHEN [订单_出库时间] <= 7 THEN ‘5-7天’
WHEN [订单_出库时间] <= 14 THEN ‘7-14天’
ELSE ‘14天以上’
END AS 出库时间区间,
COUNT(*) AS 订单数量
FROM sales_orders
GROUP BY [供应类型], [出库地点], 出库时间区间;
在仪表板中，新建堆叠柱状图， 如图所示：
但是SQL报错：SQL ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘SELECT
t_a_0.f_af76d176029d3600,
t_a_0.f_9e6935c47eece891,
C’ at line 1
DEException(code=40001, msg=SQL ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘SELECT
t_a_0.f_af76d176029d3600,
t_a_0.f_9e6935c47eece891,
C’ at line 1)