This topic describes how to configure a bubble chart to display query results.
Background information
A bubble chart shows the correlation between different categories of data. The correlation is displayed. This allows you to compare the position and area of the bubbles on the chart. You can use this type of chart to analyze the correlation between different categories of data.
A bubble chart consists of the following basic elements:
- X-axis
- Y-axis
- Bubbles
Procedure
Examples
To analyze data exceptions based on bubble sizes, execute the following query statement:

* | select date_format(from_unixtime(__time__ - __time__% 60), '%H:%i') as minute, case
when method = 'GET' and COUNT(1) > 9000 then 3 when method = 'GET' and COUNT(1) > 8500 then 2 when method = 'GET' and COUNT(1) > 8000 then 1
when method = 'POST' and COUNT(1) > 3000 then 3
when method = 'DELETE' and COUNT(1) > 1500 then 3
else 0 end as level, method group by minute, method order by minute asc limit 1000
