You can use a table to visualize the results of multiple query statements. You can also configure personalized display settings on the Field Configuration tab. This topic describes how to configure a table.
Overview
You can use tables to sort and display data for quick reference and analysis. By default, the results of query statements are displayed in tables.
For more information about the entry point to add a table, see Add a chart to a dashboard.
Configuration effect
Table type | Sample table | References |
Configuration example
Basic table
Log on to the Simple Log Service console. In the Projects section, click the project you want.
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.
![image](https://help-static-aliyun-doc.aliyuncs.com/assets/img/en-US/8483519271/p857236.png)
On the right side of the Edit Chart page, choose . Enter a query statement and click Last 15 Minutes to specify a query time range.
For example, you can enter the following statement to query the methods and status of all requests:
* | SELECT request_method,status
![image](https://help-static-aliyun-doc.aliyuncs.com/assets/img/en-US/8483519271/p856851.png)
Other settings
Operation | Description | Sample table |
Operation | Description | Sample table |
Configure the Value Mapping parameter | You can configure the Value Mapping parameter to convert and organize raw log data. This provides a clear view of the processed data that you can display on your dashboard. You can also monitor the system status and identify, troubleshoot, and analyze exceptions. For more information, see Add value mapping to a table. | ![image](https://help-static-aliyun-doc.aliyuncs.com/assets/img/en-US/6370391371/p862406.png)
|
Configure a data conversion rule of the Transpose Rows and Columns type for a table | You can configure a data conversion rule of the Transpose Rows and Columns type for a table to display raw log data from different perspectives. This way, you can view the correlation and trends of log data for better data monitoring and management. For more information, see Configure a data conversion rule of the Transpose Rows and Columns type for a table. | ![image](https://help-static-aliyun-doc.aliyuncs.com/assets/img/en-US/6370391371/p862448.png)
|
Adjust the row height and column width of a table | You can adjust the row height and column width of a table. This way, you can view data and find the required information in a more efficient manner. For more information, see Adjust the row height and column width of a table. | ![image](https://help-static-aliyun-doc.aliyuncs.com/assets/img/en-US/6370391371/p862410.png)
|
Configure a data conversion rule of the Connect type for two tables | You can configure a data conversion rule of the Connect type for two tables. This way, you can view a large number of data entries in a small space and highlight key metrics or key data. For more information, see Configure a data conversion rule of the Connect type for two tables. | ![image](https://help-static-aliyun-doc.aliyuncs.com/assets/img/en-US/6370391371/p862411.png)
|
Specify thresholds | You can specify thresholds and check whether data exceeds the specified thresholds to monitor system performance metrics, such as response time and throughput. For more information, see Specify thresholds for a table. | ![image](https://help-static-aliyun-doc.aliyuncs.com/assets/img/en-US/6370391371/p862415.png)
|
Configure settings for search and filter, variable replacement, and multi-statement query | You can configure the search and filter feature for a table. This way, you can analyze a large amount of data for further statistics collection. You can also configure variable replacement for a table. This way, you can dynamically update the data displayed in the table on a Simple Log Service dashboard. In addition, you can specify multiple query statements to generate a report from multiple dimensions. For example, you can analyze and visualize data by time, type, and user. For more information, see Configure settings for search and filter, variable replacement, and multi-statement query. | ![image](https://help-static-aliyun-doc.aliyuncs.com/assets/img/en-US/6370391371/p862418.png)
|
Configuration on the General Configurations tab
You can configure global settings for a table on the General Configurations tab.
Basic Configurations
Parameter | Description |
Title | The title of the chart. |
Display Title | If you turn on Display Title, the title of the chart is displayed. |
Display Border | If you turn on Display Border, the borders of the chart are displayed. |
Display Background | If you turn on Display Background, the background color of the chart is displayed. |
Display Time | If you turn on Display Time, the query time range of the chart is displayed. |
Fixed Time | If you turn on Fixed Time, the query time range of the chart is independent of the global time range of the dashboard. |
Standard Configurations
Parameter | Description |
Format | The display format of numeric values. |
Unit | The unit of numeric values. |
Number of Digits after Decimal Point | The decimal places of numeric values. |
Display Name | The name of the display field. If you specify a value for Display Name, the value is used as the names for all display fields in the chart. If you want to change the name of a display field, you must configure parameters on the Field Configuration tab. |
Color Scheme | The color scheme of the chart. Built-in: uses the built-in color scheme. Solid: uses the color that you select. Threshold: uses different colors for different values based on the specified thresholds for the values.
|
Parameters in the Search & Analysis Settings section
Parameter | Description |
Hide Field | The name of the field that is included in the results of a query statement and you want to hide in the table. For example, if you select __time__ from the Hide Field drop-down list, the __time__ field is hidden in the table. |
Parameters in the Table Configurations section
Parameter | Description |
Display Mode | The display mode of the table. Valid values: Paging: The table is displayed by page. You can configure the Items Per Page parameter to specify the number of rows that you want to display on each page. Contour: The table is displayed on one page. You can configure the Row Height parameter to specify the height of rows that you want to display on one page.
|
Items Per Page | The number of rows that you want to display on each page. |
Sort By | The field that you want to use to sort data in the table. |
Sorting Method | The order that you want to use to sort data in the table. Valid values: Default Ascending Descending
|
Display Header | If you turn on Display Header, the headers of the table are displayed. |
Total | If you turn on Total, the total number of rows is displayed in the table. |
Transparent Background | If you turn on Transparent Background, the background in the table is transparent. |
Parameters in the Field/Column Settings section
Parameter | Description |
Minimum Column Width | The minimum column width of the table. Unit: pixels. If you retain auto for the Column Width parameter, the column width of the table is greater than or equal to the value of the Minimum Column Width parameter. |
Column Width | The column width of the table. Unit: pixels. By default, Simple Log Service automatically calculates the column width of the table based on the size of the table and the value of the Minimum Column Width parameter. If you configure the Column Width parameter, the value is used as the column width of the table. |
Maximum Value | The maximum value of the progress bar. If you retain auto for the Maximum Value parameter, the maximum value of the column is used. The value of the Maximum Value parameter takes effect only if you set the Cell Display Mode parameter to Progress, LCD Progress Bar, or Gradient Progress Bar. |
Cell Display Mode | The display mode of cells. |
Alignment Method | The alignment method of the content in cells. |
Disable Sorting | If you turn on Disable Sorting, sorting is disabled. |
Disable Searching | If you turn on Disable Search, searching is disabled. |
Search Mode | The mode for searching data in the table. Valid values: Search: In this mode, you must specify a value to search data. Filter: In this mode, you can select a value to filter data.
|
Multiple Choices | Specifies whether to enable multiple selections when you search data in the table. Valid values: |
Exact Search | If you turn on Exact Search, only exact search is supported. |
Font Size | The font size of the content in cells. |
Show All | If you turn on Show All, field values are fully displayed in the table. |
Parameters in the Threshold section
Parameter | Description |
Threshold | The threshold of numeric values. If you set the Color Scheme parameter to Threshold and specify thresholds in the Threshold section, the text in the table is displayed in different colors based on the specified thresholds. |
Parameters in the Variable Replacement section
Parameter | Description |
Variable Replacement | The settings for variable replacement. You can click AddVariable Replacement to add a filter of the Variable Replacement type to the table. After you configure the settings for variable replacement on the General Configurations tab, Simple Log Service adds a filter in the upper-left corner of the table. You can select a value from the filter drop-down list. Then, Simple Log Service automatically replaces the variable in the query statement of the table with the variable value indicated by the value that you select, and performs a query and analysis operation. For more information, see Example 2: Configure variable replacement. |
Parameters in the Value Mapping section
Parameter | Description |
Value Mapping | The text or icon that you want to use to replace a specified value in the table. For example, if you set the Value parameter to 200, the Mapping Type parameter to Text, and the Mapping Value parameter to Success, all values of 200 in the table are replaced with Success. |
Parameters in the Documentation section
Parameter | Description |
Add Documentation Link | The button that allows you to specify custom document links and descriptions. After you configure the settings, the specified information is displayed in the upper right corner of the table. |
Configuration on the Field Configuration tab
You can configure personalized display settings for the results of a single query statement or for a single column of data in the results. For more information, see Configuration on the General Configurations tab.
For example, you can select A > pv to configure settings for the pv field in the results of Query Statemnt A. If you select Text Highlight from the Field/Column Settings > Cell Display Mode drop-down list, the values of the pv field are highlighted and are displayed in different colors based on the specified thresholds.
![表格Pro](https://help-static-aliyun-doc.aliyuncs.com/assets/img/en-US/2459046561/p349335.png)
Configuration on the Interaction Occurrences tab
You can configure an interaction occurrence for the results of a single query statement or for a single column of data in the results to analyze data in a finer-grained manner. Supported types of interaction occurrences include Open Logstore, Open Saved Search, Open Dashboard, Open Trace Analysis, Open Trace Details, and Create Custom HTTP URL. For more information, see Interaction occurrences.
For example, you can select A > pv to configure an Open Logstore interaction occurrence for the pv field in the results of Query Statement A. After you configure the interaction occurrence, you can move the pointer over a value of the pv field in the table and click Open Logstore. Then, you are navigated to the Logstore that you specify.
![表格Pro](https://help-static-aliyun-doc.aliyuncs.com/assets/img/en-US/2459046561/p349341.png)