Classic row-by-column spreadsheet like view of a dataset. Use tables to showcase a view into the underlying data or to show aggregated metrics.
In this walkthrough, we will create a table chart that shows the top 10 timezones of Slack users.
The following articles may be useful resources as you build your chart:
- Creating a Chart: A walkthrough of the overall process of chart selection and creation.
- Using Preset Explore: How to work with the Explore page, the primary interface used when creating a chart.
Step 1: Create New Chart
To create a table chart, in the Toolbar, select + Chart.
The Create a new chart screen appears.
In the Choose a Dataset field, select a dataset to build your query from. In this case, we are selecting a dataset that includes data about usage of the messaging platform Slack.
Select a Table in the chart gallery. Since it is included in the default recommended tag of #Popular, the table chart option is already listed.
Next, select Create New Chart.
Step 2: Configure the Chart
Reference: How to Configure the Time
The first step is to define the Time Column field. This field contains a time-related column from the dataset. More than likely, this field is pre-populated for you.
You can recognize time columns by looking in the Columns listing in the Metrics & Columns panel and finding those with a small clock icon.
In this example, there is only one time column available, so there is no need to make any changes to the Time Column field.
The Time Grain field is used to specify the granularity in terms of how frequently data is presented in the visualization. Preset supports a range of granularities from a second up to a year, and everything in-between.
For this example, we will select Day.
Next, let's configure the Time Range field.
This field is used to specify a date & time range from which data will be extracted for the query. Generally-speaking, if you're working with a small dataset size, then it is best to use the No filter option (i.e., use all available data). If the dataset size is larger, though, then a date & time range is more appropriate.
In this case, due to the limited size of the dataset, we will use the No filter time range option.
The completed Time panel looks as follows:
For the configuration we will use Slack user data and we will limit the rows to 10.
Let's start by dragging the tz (timezone) column and dropping it into the Group By field.
In the Metrics field, we will add the COUNT metric. In addition we will specify Aggregate as this chart's query mode.
Lastly, we will specify a Row Limit of 10.
Here is how it's done:
The completed Query panel looks as follows:
Step 3: Run the Query
Reference: The Content Panel
Select Run or, in the Content panel, Run Query.
The table chart appears in the Content panel.
Most Preset charts are interactive, so feel free to hover your cursor over different elements of the visualization to get more data.
Additionally, you can expand the Data section to view data results and samples from the query.
Step 4: Finalizing the Chart
If you're happy with the visualization, be sure to give it a name:
If you'd like to customize your visualization, select the Customize tab.