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.

Procedure

1. Log on to the Log Service console.
2. In the Projects section, click the name of the project that you want to manage.
3. Choose Log Storage > Logstores and click the Logstore that you want to manage.
4. Enter a query statement in the search box, select a time range, and then click Search & Analyze.
5. On the Graph tab, click the icon.
6. On the Properties tab, configure the properties of the bubble chart.

   Parameter	Description
   X Axis	The categorical variable. In most cases, time series is selected.
   Y Axis	The value of the categorical variable. You can select one or more fields for the Y-axis.
   Value Column	The field that is displayed by using bubbles. The bubble sizes indicate field values.
   Shape	The shape of the bubbles. Default value: Circle.
   Bubble Size	The size ranges allowed for bubbles. Valid values: 0 to 32.
   Bubble Color	The color of the bubbles.

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