Charts

In Apache Superset, a chart refers to a visual representation of data from a dataset. It can be of different types, such as Bar Chart, Pie Chart, Treemap, Table, etc.

Charts can be combined into dashboards, which provide a comprehensive view of data across multiple charts.

In this section, you will create three charts for visualizing employees' salaries data:

  • Bar Chart

  • Table

  • Big Number

Bar Chart

The Bar Chart will show the salary of each employee. To create a new chart navigate to Charts in the top menu and create click on + CHART button.

In the opened screen:

  • Select Employees' salaries dataset.

  • Select Bar Chart.

  • Click on CREATE NEW CHART button.

In the chart configuration:

  • Drop the full_name column to the X-AXIS field.

  • Drop salary column to the METRICS field with SUM aggregation:

sum salary

  • click on CREATE CHART button, and you will see the following result:

bar chart

Set the name for this chart - Salary by employee and save without adding to a dashboard.

Table

The Table chart will show an average salary by department. Navigate to Charts in the top menu and create a new chart by clicking on + CHART button.

In the opened screen:

  • Select Employees' salaries dataset.

  • Select Table chart.

  • Click on CREATE NEW CHART button.

In the chart configuration:

  • Drop the department_name column to the DIMENSIONS field.

Then create an aggregation by the salary column:

  • Click on METRICS field.

  • Select SIMPLE tab, choose AVG aggregation for the salary column and save changes.

avg salary

  • Click on CREATE CHART, and you will see the following result:

table chart

Set the name for this chart - Salary by department and save without adding to a dashboard.

Big Number

The Big Number chart type is used to display a single, prominent metric or value. In your dashboard, it will show the average salary of all employees.

Navigate to Charts in the top menu and create a new chart by clicking on + CHART button.

In the opened screen:

  • Select Employees' salaries dataset.

  • Select Big Number chart type.

  • Click on CREATE NEW CHART button.

In the chart configuration:

  • Drop the salary column to the METRICS field.

  • Select AVG aggregation and save it.

avg salary

  • In the SUBHEADER field enter Employees' AVG salary.

  • Click on CREATE CHART and you will see the following result:

big number chart

Set the name for this chart - Employees' AVG salary and save without adding to a dashboard.