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

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
主站蜘蛛池模板: 梧州市| 鄂州市| 南江县| 吴江市| 肇庆市| 姚安县| 清水河县| 浦江县| 丰宁| 河北区| 庆安县| 海宁市| 通辽市| 湟源县| 崇信县| 潜江市| 民权县| 鞍山市| 堆龙德庆县| 通化市| 克什克腾旗| 临沭县| 锦州市| 兴义市| 莱州市| 寿阳县| 江北区| 来凤县| 称多县| 偃师市| 防城港市| 武夷山市| 雅江县| 虞城县| 阿坝县| 呼图壁县| 宝应县| 布拖县| 静海县| 佳木斯市| 临清市|