本文介绍时间轴图表操作步骤及示例。
简介
时间轴是依据时间顺序,把一方面或多方面的事件串联起来,形成相对完整的记录体系。通过时间轴,可清晰的观测到数据在某一个时间点的数据情况,它的优点主要是具有连续性和准确性。
操作步骤
示例
type: news | select news_time as "发布时间", author as "发布者", title as "标题", source as "来源网站",
case when strpos(url, 'https://') = 1 then substr(url, 9) when strpos(url, 'http://') = 1 then substr(url, 8) else url end as url from log l right join
(select max(version) as version from log) r on l.version = r.version order by news_time asc limit 50