A multi-axis chart allows you to view differences among multiple metrics on the dashboard. You can assign aliases and colors to each metric for easier distinction.
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.
Enter the query and analysis statement, and set the time range for your query and analysis, such as Last 15 Minutes.
Example:
* | 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 > Save.: Set Axis X Field to
__time__, and Axis Y Field topv,pv1, andpv2.
Step 3: Set aliases and colors
Set aliases
: Assign aliases to the axis Y fields.
Set colors
: Set different colors for different fields of the axis Y.
