Simple Log Service:Configure chart types

Overview

1. Search & Analysis: Use this feature to query and analyze logs in the Log Service console for tasks such as log searches, aggregation, and statistical analysis.

2. Add a chart: A dashboard consists of multiple charts. Each chart represents one or more query and analysis statements.

3. Configure chart types (line, area, column, and cross table): Set the type for the flow chart.

Step 1: Query and analyze data

1. Log on to the Simple Log Service console. In the Projects section, click the project you want.

   

2. On the Log Storage > Logstores tab, click the logstore you want.

   

3. Enter a query and analysis statement, and then click Last 15 Minutes to set the time range for the query.

   Example:

   • The following is an example statement:

     * | select __time__,count(0) as pv group by request_method,__time__

Step 2: Add a chart

1. 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, choose Add > Add Chart.

   

2. In the General Configurations > Chart Types > . On the Search & Analysis tab, select Logstore (SQL), choose the target Logstore, and enter a query statement.

   In the upper-right corner of the page, select a time range, such as Last 15 Minutes. Then, click OK > Save.

   • Under Query and Analysis Configurations, set Axis X Field to __time__ and Axis Y Field to pv.

   The __time__ field for the x-axis uses the UNIX timestamp format. To display the time in a standard format, enable Time Series Mode and set Format for the x-axis to YYYY-MM-DD hh:mm:ss. For more information, see Time series mode.

   

Step 3: Configure chart types

Line chart

To display the pv field as a line chart, choose Flow Chart Configurations > Flow Chart Type > Line Chart.

Area chart

To display the pv field as an area chart, choose Flow Chart Configurations > Flow Chart Type > Area Chart.

Column chart

To display the pv field as a column chart, choose Flow Chart Configurations > Flow Chart Type > Column Chart.

Cross table

To display the pv field as a cross table, choose Flow Chart Configurations > Flow Chart Type > Cross Table.