Table Chart
  • 02 Aug 2022
  • 3 Minutes to read
  • Contributors
  • Dark
    Light

Table Chart

  • Dark
    Light

Overview

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.

Reference Content

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.

Create_Table_Chart


Step 2: Configure the Chart

Time Panel

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:

Table_Time_Panel

Query Panel

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:

Table_Chart_Query

The completed Query panel looks as follows:

Table_Chart_Query_Panel


Step 3: Run the Query

Reference: The Content Panel

Select Run or, in the Content panel, Run Query.

Run_Query

The table chart appears in the Content panel.

Ran_Query_Table_Chart

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:

Enter_Chart_Title_Here

If you'd like to customize your visualization, select the Customize tab.

Lastly, be sure to save your chart. Remember that you can also save your chart to a dashboard—or create a brand new dashboard—directly from the Save menu!

Final Chart

Final_Table


Was this article helpful?

What's Next