This topic describes how to configure a table to display query results.
Chart upgrade
Log Service provides charts (Pro) to display query and analysis results. You can use a chart (Pro) to visualize the results of multiple query statements. You can also configure custom settings for fields. You can click Migrate to convert a common table to a table (Pro). For more information about the table (Pro), see Table (Pro).
- You cannot transpose the rows or columns of a table (Pro).
- After you convert a common chart to a chart (Pro), you cannot convert the chart (Pro) to a common chart.
Background information
Tables are used to sort and display data for quick reference and analysis. All query results that match specified query statements can be rendered into visualized charts. By default, the query results are displayed in a table.
Procedure
Examples

- To filter the request_method, request_uri, and request_time fields in the latest 10 logs, execute the following query statement:
* | SELECT request_method, request_uri, request_time GROUP BY request_method, request_uri, request_time LIMIT 10
- To query the average of the request_time field values (the average request time) in a specified time range and round the average
to three decimal places, execute the following query statement:
* | SELECT round(avg(request_time), 3) as average_request
- To group the values of the remote_addr field in a specified time range and sort the values in descending order, execute
the following query statement:
* | SELECT remote_addr, count(*) as count GROUP BY remote_addr ORDER BY count DESC