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

  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 Bubble chart icon.
  6. On the Properties tab, configure the properties of the bubble chart.
    ParameterDescription
    X AxisThe categorical variable. In most cases, time series is selected.
    Y AxisThe value of the categorical variable. You can select one or more fields for the Y-axis.
    Value ColumnThe field that is displayed by using bubbles. The bubble sizes indicate field values.
    ShapeThe shape of the bubbles. Default value: Circle.
    Bubble SizeThe size ranges allowed for bubbles. Valid values: 0 to 32.
    Bubble ColorThe 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
Bubble Chart - 001