This topic describes how to view query results in a bubble chart.
Background information
A bubble chart shows bubbles in different sizes and at different positions. You can analyze the correlation between data based on the bubble chart.
A bubble chart consists of the following 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 request_method = 'GET' and COUNT(1) > 9000 then 3 when request_method = 'GET' and COUNT(1) > 8500 then 2 when request_method = 'GET' and COUNT(1) > 8000 then 1
when request_method = 'POST' and COUNT(1) > 3000 then 3
when request_method = 'DELETE' and COUNT(1) > 1500 then 3
else 0 end as level, request_method group by minute, request_method order by minute asc limit 1000
