The Bubble chart is a playful way to display how many values you have per category. The higher the value, the bigger the bubble so you can see your biggest categories in a glimpse. Which you can also visually group together by color.
Let’s dive into more detail!
The Bubble chart can be found underneath the special charts section. By drag & dropping it into the canvas, data can be added to the three dataslots ‘category’, ‘measure’ and ‘color. Let’s focus on each of them, illustrated with an example.
Columns with data types ‘hierarchy’ are a perfect fit for this slot.
The data added to the category slot defines how many bubbles - or categories - will appear, as such five different values will result in five bubbles. The measures from the same value will be aggregated into one.
The example below demonstrates how a column with product names is added to the chart. Without measure data, each bubble represents the number of rows per product found in the dataset, which is like the count aggregation.
Columns with data type ‘numeric’ are a perfect fit for this slot.
The measure slot defines the numeric value of a category. The higher the value, the bigger the bubble. Different aggregations can be set in order to be able to execute different calculations, e.g. the average.
In this example, we use a column containing volume data to show the amount of sales per product. The aggregation is also changed to average.
Columns with data type ‘hierarchy’ are a perfect fit for this slot.
This third slot gives the opportunity to analyze data in an extra dimension. By adding data, the bubbles will show groups by color resulting in enhanced insights.
In the example, we group the bubbles according to the transaction type.
The values of the bubbles can be displayed by toggling on the ‘show values’ option in the settings of the chart. You can choose to display the absolute values or the percentages, where the amount of bubbles displayed is 100%.
In the advanced settings, you can choose the number of bubbles displayed. These will be your biggest categories, which you could compare to a top 10 function.
The legend in this chart can be used to show or hide specific elements by clicking them.