superset1.4.0 创建折线图,按时间显示热度

导入数据

INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2021-12-23', 4);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-03-30', 2);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-01-20', 6);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-03-02', 4);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-04-04', 2);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2021-11-18', 8);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-01-17', 2);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-03-16', 4);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2021-12-24', 4);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-04-12', 2);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-04-02', 4);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2021-12-29', 2);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2021-12-13', 4);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-03-25', 52);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2021-11-08', 2);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-04-19', 82);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-02-28', 2);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-03-06', 4);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-01-25', 4);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-03-01', 2);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-02-18', 4);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-03-26', 112);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-04-18', 48);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-04-01', 2);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-01-21', 6);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2021-12-14', 4);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2021-12-01', 2);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-02-23', 2);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-03-22', 4);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-03-15', 8);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-01-13', 2);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2021-12-10', 2);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-04-14', 8);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-04-13', 6);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-03-24', 6);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-02-21', 2);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-02-15', 2);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-03-31', 4);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-04-15', 4);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-02-10', 2);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2021-12-20', 4);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2021-12-15', 4);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-04-05', 2);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2021-11-09', 4);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-04-23', 214);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-01-11', 2);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-02-08', 2);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2021-11-22', 4);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-04-07', 4);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-04-06', 2);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-01-10', 2);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-03-13', 2);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-04-22', 232);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-04-08', 2);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-02-25', 2);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-01-15', 2);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2021-12-16', 4);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-02-11', 2);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-02-09', 2);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-02-16', 2);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-01-19', 4);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2021-11-30', 4);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2021-11-10', 4);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-04-20', 148);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2021-12-27', 4);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-03-14', 2);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-04-24', 290);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2021-11-11', 4);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-04-21', 238);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-03-18', 8);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-02-22', 2);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2021-11-16', 4);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-03-23', 2);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-02-07', 2);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-03-17', 8);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-01-28', 4);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-03-19', 8);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-02-17', 4);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-01-26', 4);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2021-12-22', 4);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-04-03', 6);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-01-12', 2);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-01-27', 8);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-01-07', 2);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-01-29', 2);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-03-07', 54);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-01-24', 8);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2022-02-14', 2);
INSERT INTO `t_date_statistics`(`date`, `count`) VALUES ('2021-11-29', 4);

添加 Databases

创建折线图

点击下面按钮

选择时间维度字段

选择统计字段


原文出处:http://malaoshi.top/show_1IX3M0uPUXkz.html