时间戳

首页 > 解决方案 > 如何通过apache超集中的rest api创建虚拟数据集和图表？

apache-superset - 如何通过apache超集中的rest api创建虚拟数据集和图表？

问题描述

这是我的 sql 实验室代码

SELECT names AS names, sum( Total_Work_Hr) AS SUM(Total_Work_Hr), sum( Contractual_Hr) AS SUM(Contractual_Hr), sum( Time_Deviation) AS SUM(Time_Deviation)FROM (SELECT concat(employee_details.firstname, " ", employee_details.lastname) as names, Total_Work_Hr, Contractual_Hr, Time_Deviation, Data_date FROM employee_attendance INNER JOIN employee_details ON >employee_details.employee_id = employee_attendance.employee_id WHERE employee_attendance.Data_Date >= STR_TO_DATE('1990-01-08', '%Y-%m-%d') AND employee_attendance.Data_Date < STR_TO_DATE('2021-07-08' , '%Y-%m-%d') GROUP BY names) AS expr_qry GROUP BY 名称 LIMIT 1000;""

但我试图通过邮递员 api 调用创建同一张图表。购物车已生成，但结果完全不同

错误图像

我发现我新创建的图表 sql 查询发生了变化

""SELECT (names) A​​S names, DATE( Data_Date) AS __timestamp, COUNT(*) AS count, sum(Total_Work_Hr) FROM (SELECT concat(employee_details.firstname, "", employee_details.lastname) as names, employee_attendance.Total_Work_Hr, employee_attendance .Contractual_Hr, employee_attendance.Time_Deviation, Data_Date FROM employee_attendance INNER JOIN employee_details ON employee_details.employee_id = employee_attendance.employee_id) AS expr_qry GROUP BY (names), DATE( Data_Date) LIMIT 1000;""

请帮忙。创建图表的正确方法是什么，我在哪里可以找到图表参数

标签： apache-superset

解决方案

推荐阅读