This topic explains how to configure the X axis and Y axis of a line chart.
Prerequisites
Log data is collected. For more information, see Collect text logs from servers.
Indexes are created. For more information, see Create indexes.
Step 1: Query and analyze data
Log on to the Simple Log Service console. In the Projects section, click the project you want.
In the left-side navigation pane, click Log Storage. In the Logstores list, click the logstore you want.
Input the query and analysis statement and click Last 15 Minutes to define the time range for the query and analysis.
Example:
* | select __time__,count(request_url) as pv group by __time__
Step 2: Add a chart
In the left-side navigation pane, choose Dashboard > Dashboards. In the dashboard list, click the dashboard you want. In the upper-right corner of the dashboard page, click Edit. In edit mode, click Add > Add Chart.
On the General Configurations tab, click
in the Chart Types section. On the Search & Analysis tab, select Logstore (SQL) and choose the logstore you want, and enter the query statement. Select a time range, such as Last 15 Minutes, and click OK > Save.: Set Axis X Field to
__time__, and Axis Y Field topv.
Step 3: Configure the X axis and Y axis
Configure the X axis
Show or hide the X axis
Axis X > Display Axis X: Set Display Axis X to display or hide the axis X on the chart.
Format the X axis
Axis X formatting is available only in time series mode. The following figure shows the Time Series Mode switch and the time formatting settings:
Configure the Y axis
Show or hide the Y axis
Axis Y > Display Axis Y: Set Display Axis Y to display or hide the Y axis on the chart.
Maximum and minimum values
The following figure shows how to define the maximum and minimum values for the Y axis:
Set multiple line charts
Update the query statement to: * | select __time__, count(request_url) as pv, count(request_url)-50 as pv1, count(request_url)+50 as pv2 group by __time__.
Query Analysis Configurations > A > Axis Y Field: Select the fields pv, pv1, and pv2.
Set thresholds
: Assign pv2 as the Upper Boundary and pv1 as the Lower Boundary. Select red as the Boundary Fill Color.
