How-To Guides
...
Reporting Guides
Create Your Own Report with Re...

Creating Table Visualization

6min

This is the fifth step of creating your own report with the Reporting module.

In this section, we’ll create our first visualization: a table to show the number of flights and cost per travel class.

To create a new chart:

  1. Select New > Chart.
Document image

  • Once in the Create a new chart dialogue, select tutorial_flights from the Choose a datasource dropdown.
Document image




  • Next, select the visualization type as Table.
Document image

  • Then, select Create new chart to go into the chart view.
  • By default, Apache Superset only shows the last week of data: in our example, we want to look at all the data in the dataset.

No problem - within the Time section, remove the filter on Time range by selecting Last week then changing the selection to No filter, with a final OK to confirm your selection.

Document image

  • Now, we want to specify the rows in our table by using the Group by option. Since, in this example, we want to understand different Travel Classes, we select Travel Class in this menu.
  • Next, we can specify the metrics we would like to see in our table with the Metrics option. Count(*), which represents the number of rows in the table (in this case, corresponding to the number of flights since we have a row per flight), is already there. To add cost, within Metrics, select Cost. Save the default aggregation option, which is to sum the column.
Document image

  • Finally, select Run Query to see the results of the table.
Document image


Congratulations, you have created your first visualization in Apache Superset!

Save Your Visualization

To save the visualization:

  1. Click on Save in the top left of the screen.
  2. Select the Save as option, and enter the chart name as Tutorial Table (you will be able to find it again through the Charts screen, accessible in the top menu).
  3. Similarly, select Add to new dashboard and enter Tutorial Dashboard. Finally, select Save & go to dashboard.
Document image