官术网_书友最值得收藏!

Creating a visualization

That was smooth! You were able to add your first database and table to Superset. Now, it's time for the fun part, which is visualizing and analyzing the data. In Table, we will find the bigquery-public-data.stackoverflow.posts_questions listed as follows:

List Tables shows all available tables that can be used to make charts

When you click on it, it will take you to the chart UI:

Options available to modify the data visualized in the chart

Here, we will make a time series plot of the number of questions posted by year. In the Data tab, the Time section is used to restrict data by a temporal column value. We do not want to restrict data for the time series plot. We can clear the Since field.

In order to add axis labels to the line chart, select the Style tab and add descriptions in the X Axis Label and Y Axis Label fields:

Style form for the chart

Set year as Time Grain and COUNT(*) as the Metrics. Finally, hit Run Query:

Line chart showing total number of questions posted on Stack Overflow from 2008-2018

We have our first visualization! We can see how the number of questions grew quickly from 2008-2013. Now, Save the visualization, so that we can add it to our dashboard later:

A name and dashboard can be assigned to the chart on the Save form
主站蜘蛛池模板: 齐河县| 尼勒克县| 安顺市| 聊城市| 黎川县| 盐城市| 祁门县| 龙岩市| 肇东市| 西宁市| 新野县| 如东县| 乌拉特中旗| 永川市| 永定县| 英超| 宽城| 炎陵县| 北安市| 新化县| 通城县| 屏东县| 磐安县| 庄浪县| 巢湖市| 金川县| 石楼县| 沅陵县| 湾仔区| 池州市| 商河县| 雷州市| 绵阳市| 台南市| 望都县| 和静县| 奉化市| 麻城市| 道孚县| 大埔县| 年辖:市辖区|