Through the study in the previous chapter, we have successfully installed SuperSet, connected to the MySQL database, and visualized the data of King Hero. The simplest Table type of chart is used, but SuperSet supports a wide variety of chart types.

In this article, we will demonstrate the various types of charts one by one. The article is longer, and it is recommended to read after collection.

Classification of the chart

SuperSet provides a large number of charts to help us visualize the data.

The types of charts can be divided into the following categories:

  • Time series charts: This type of chart shows data over time and is best for spotting trends. Examples of time series diagrams include line charts, time series bar charts, and so on.
  • Combination charts: These types of charts show how data is distributed in a particular area, such as “Up to…” , “At least…” And “Top 10” type charts. Examples of composite graphs include bar charts, pie charts, and tree charts.
  • Distribution: This type of chart shows how the data is distributed in one or more fields. It is best used for data with multi-dimensional properties. Examples of distribution maps include histograms, box plots, and horizontal plots.
  • Diagram: This type of diagram shows the relationship between two or more variables. It is often used to convey generic, non-generic, or causal types. Examples of diagrams include PivotTables, Heat Maps, and Bubble Charts.
  • Geospatial charts: This type of chart shows geographically based data. SuperSet also provides a variety of geospatial charts based on deck.gl.

Only by choosing the right diagram can you convey exactly what you want to express. So how do you determine the chart type?

The first thing to think about is what you want to achieve. A good diagram must be a clear answer to the question. Here are some selection criteria for your reference:

  • Use a time series chart when you want to show how the data changes over time (for example, changes in product sales during the last quarter).
  • Use a composite chart when your data focuses on a single factor (for example, number of graduates, most popular cities, etc.).
  • Use a distribution map when your data is assigned to different categories (for example, the distribution of people in an interval, etc.).
  • Use the diagram when you compare two or more values (for example, sea level rise compared to temperature change).
  • Use geospatial charts when your data depends on geography (for example, the population density of a city, air traffic routes, and so on).

Data set preparation

For these charts, different data sets are prepared for visualization. Respectively is:

Time series chart: “Big Joe” keyword, search index change data in recent one month.

Combination chart: ranking of the maximum health of each hero of King.

Distribution: Maximum health of each hero of King, and statistics of the number of heroes in each health interval.

Diagram: Look at the relationship between maximum defense and maximum life.

Geospatial chart: Here is a simple visualization of the number of people diagnosed with COVID-11 in the United States and India.

Here’s how to use the different types of charts:

1. Time series chart

First get the data ready. The data comes from Big Joe’s search index data.

First go to the DataSets page and add the table.

After the table has been successfully joined, go to the Charts page and create a new chart.

Select the Chart type as Time-Series Bar Chart

New chart

Go to the chart Settings page, where you can set the chart in a series of Settings, first change the name.

The default table statistic is COUNT, change it to SUM.

Modify the time range. Default is Last Week.

You can also do some custom Settings, colors, axes and so on.

Save, and the time series diagram is completed successfully.

2. Combine charts

This data source uses King Hero data and was previously associated. Let’s use this data to make a pie chart.

To start, create a new Chart and select the type Pie Chart

Choose Your Data Source

To do the basic setup, here the hero group, statistical dimension is maximum life

Do some custom Settings

Click Run to query, and the pie chart is ready.

III. Distribution chart

Again, using the Heroes of Kings data, make a histogram

First, create a new chart, and select the chart type as Histogram

Make some customizations

Select the statistics as the maximum life and adjust the interval.

You can see the distribution of maximum health clearly.

Click Run to query, and you have your histogram ready. Save it.

Four, the relationship chart

Still using existing data

Select a Heatmap type chart

Then do some basic setup, X axis select maximum material

On the Y-axis, I choose maximum life.

I’m going to hit Run and I’m going to do my heat map. Save it.

5. Geospatial chart

With the data ready, select the chart type as World Map

Make some Settings, country codes, statistical columns, etc.

Click Run to query and save.

In this article, we have gained a basic understanding of the various charts in SuperSet. What else does SuperSet do? The next chapter continues