Build a Log Dashboard with Charts and Filters - Simple Log Service

Simple Log Service provides dashboards to visualize query and analysis results as charts, such as column charts, line charts, and pie charts. You can use dashboards to monitor the status of your systems, applications, and services. This topic shows you how to create a dashboard.

Quick start

This example creates a dashboard based on a CLB access log to monitor page view (PV) trends for different request methods. It also shows you how to add a filter to view the PV trend for a specific request method. A sample log is as follows:

{
    "body_bytes_sent": "1346",
    "client_ip": "118.*.*.125",
    "host": "www.*.*.com",
    "http_host": "www.*.*.com",
    "request_length": "15**",
    "request_method": "PUT",
    "request_time": "26",
    "scheme": "https",
    "slbid": "slb-02",
    "status": "200",
    "upstream_addr": "133.*.*.113",
    "upstream_response_time": "18",
    "upstream_status": "200",
    "vip_addr": "39.*.*.121",
    "__pack_meta__": "1|MTcyNDE*==|120|119",
    "__topic__": "slb_layer7",
    "__source__": "127.0.0.1",
    "__tag__:__receive_time__": "1725349464",
    "__tag__:__receive_time___0": "1725349464",
    "__time__": "1725349464"
}

To create a dashboard in Simple Log Service, follow these three steps:

Add a dashboard: First, add a dashboard in the Simple Log Service console to hold your related charts.
Add a chart: Next, add a chart to the dashboard to visualize your query results.
Add a filter: Finally, add a filter to refine the chart's data based on specific fields in your query statement.

1. Add a dashboard

Log on to the Simple Log Service console, select the target project, and then navigate to the Dashboard > Dashboards page to add a dashboard.

2. Add a chart

Click Add New Chart.
Configure and save the chart:
1. On the left side of the page, configure the time range, Logstore, and query statement.
2. On the right side of the page, configure the chart type, x-axis, y-axis, and aggregation columns. Click Apply at the top of the page to preview the chart, and then click OK to save the chart.
  
  The query statement is as follows:
```
SELECT 
    DATE_FORMAT(DATE_TRUNC('minute', __time__), '%m-%d %H:%i') AS t,
    request_method,
    COUNT(*) AS pv
GROUP BY 
    t, 
    request_method
ORDER BY 
    t ASC
LIMIT 10000;
```
Drag the chart to resize it, and then click Save in the upper-right corner.

3. Add a filter

The chart currently displays the PV for all request methods. To view the PV for only specific methods without modifying the query statement, you can add a filter and select the desired methods from a drop-down list.

On the dashboard page, click Edit in the upper-right corner to enter edit mode. Click the button at the top of the page to create a filter.
Configure the filter.

A filter searches the original query results for logs that contain a specific Key:Value pair.

In the panel on the right, set the Key to request_method as the filter condition. Then, enable the Add Dynamic List Item toggle and enter the query statement *|select distinct request_method to retrieve all unique values of the request_method field. These values will populate the filter's drop-down list.
Click Save in the upper-right corner of the dashboard.
From the drop-down list, select POST. The chart then displays the PV only for the selected request method.

Simple Log Service:Create a dashboard

Quick start

1. Add a dashboard

2. Add a chart

3. Add a filter

Related documents