You can use a multi-axis chart to view the differences of multiple metrics on the same dashboard. You can configure a chart type such as Line, Column, or Point for each metric on the chart.
Prerequisites
Log data is collected. For more information, see Collect text logs from servers.
Indexes are created. For more information, see Create indexes.
Effect preview
Query and analyze data: You can query and analyze the collected logs in the Simple Log Service console. For example, you can retrieve logs, aggregate logs, and collect statistics on logs.
Add a chart: Each dashboard consists of multiple charts. Each chart displays the results of one or more query statements.
Configure chart type settings: Configure a chart type such as Line, Column, or Point for each metric indicated by different y axes.
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 your query.
Example:
Here is the query statement for Query Analysis A:
* | select __time__,count(request_url) as pv,count(request_url)-50 as pv1,count(request_url)+50 as pv2 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.: Set Axis X Field to
__time__, and Axis Y Field topv,pv1,pv2.
Step 3: Configure chart type settings
Column
: Display the pv field in columns.
Point
: Display the pv1 field in points.
