最简单的折线图

  • 查询语句
select count_date,area2,count_day as 'day_A' from ims_platformonlinesum group by count_date,area2
  • 配置
sine: 28 days ago
until: now
metircs: sum__day_A
groupby: area2

# 图标
X Axis Label: 时间(日期)
Y Axis Label: 新增数量(台)
X Axis Format:

数据清单

  • 查询语句
select count_date,area2 as 'City',format((count_day),0) as 'DayNew_Our',format(sum(count_month),0) as 'MonthNew_Our',format(sum(count_year),0) as 'YearNew_Our',format(sum(count_total),0) as 'ALL_Our',format(sum(count_day_other),0) as 'DayNew_Others',format(sum(count_month_other),0) as 'MonthNew_Others',format(sum(count_year_other),0) as 'YearNew_Others',format(sum(count_total_other),0) as 'All_Others',format(sum(count_day_all),0) as 'DayNew_ALL',format(sum(count_month_all),0) as 'MonthNew_ALL',format(sum(count_year_all),0) as 'YearNew_ALL',format(sum(count_total_all),0) as 'ALL_ALL' from ims_platformonlinesum group by area2,count_date order by count_date,FIELD(area2,'梁山','济宁','济南','莱芜','聊城','德州','泰安','枣庄','潍坊','烟台','青岛','威海','日照','东营','淄博','临沂','滨州','菏泽','湖北省(鄂)','上海市(沪)','江西省(赣)','黑龙江省(黑)','贵州省(贵)','四川省(川)','云南省(云)','广东省(粤)','内蒙古(蒙)','辽宁省(辽)','浙江省(浙)','陕西省(陕)','山西省(晋)','吉林省(吉)','河北省(冀)','河南省(豫)','江苏省(苏)','甘肃省(甘)')
  • 配置
Visualization Type: Table View
Time: sine 2 days ago, 因为这样的话,我们会有昨日的数据
Groupby : city, daynew_our
metrics: 留空

双柱形

  • 查询语句

  • 配置

virtualization type: Distribution - Bar Chart
sine : 28 days ago
metrics: sum__day_A
group by : areaa2
chart options: show makers; line stype: basic
Copyright © opschina.org 2017 with zzlyzq@gmail.com all right reserved,powered by Gitbook该文件修订时间: 2017-07-11 11:32:48

results matching ""

    No results matching ""