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

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
主站蜘蛛池模板: 九江县| 永康市| 婺源县| 壶关县| 馆陶县| 衡南县| 准格尔旗| 海晏县| 南阳市| 麻栗坡县| 馆陶县| 府谷县| 灵宝市| 彭州市| 胶州市| 丰顺县| 雅安市| 通城县| 勃利县| 茶陵县| 白山市| 昌宁县| 海宁市| 凤阳县| 慈溪市| 孟连| 沂源县| 赣榆县| 平武县| 东乡县| 华池县| 于田县| 东丽区| 颍上县| 双江| 深泽县| 建德市| 康保县| 阳城县| 开远市| 梧州市|