You can use a table (Pro) to visualize the results of multiple query statements. You can also configure personalized display settings on the Fields tab. This topic describes the basic configurations of a table (Pro).
Introduction
Tables are used 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 how to create a table, see Add a chart (Pro) to a dashboard.
Configurations on the Common Settings tab
You can configure global settings for a table on the Common Settings tab.
Parameters in the Basic Configurations section
Parameter
Description
Title
The title of the table.
Show Title
If you turn on Show Title, the title of the table is displayed.
Show Border
If you turn on Show Border, the borders of the table are displayed.
Show Background
If you turn on Show Background, the background color of the table is displayed.
Show Time
If you turn on Show Time, the time range of the query is displayed in the table.
Fixed Time
If you turn on Fixed Time, the time range of the query for the table is independent of the global time range of the dashboard.
Parameters in the Standard Configurations section
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 table header.
If you specify a value for Display Name, the value is used as the names for all headers in the table. If you want to change the name of a header, you must configure parameters on the Fields tab.
Color Scheme
The color scheme of the table. The color scheme is applied to the background and text of the table.
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.
Paging: The table is displayed by page. You can configure Items Per Page 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 Row Height to specify the height of rows that you want to display on one page.
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 Column Settings section
Parameter
Description
Minimum Column Width
The minimum column width of the table. Unit: pixels.
If you retain auto for Column Width, the column width of the table is greater than or equal to the value of Minimum Column Width.
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 Minimum Column Width. If you specify a value for Column Width, the value is used as the column width.
Max Value
The maximum value of the progress bar. If you retain auto for Max Value, the maximum value of the column is used.
Max Value takes effect only when you set Cell Display Mode 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.
Size
The font size of the content in cells.
Parameters in the Threshold section
Parameter
Description
Threshold
The threshold of numeric values.
If you set Color Scheme to Threshold and specify thresholds for values in the Threshold section, the values in the table are displayed in different colors based on the specified thresholds.
Parameters in the Replace Variable section
Parameter
Description
Replace Variable
The settings of variable replacement. You can click AddReplace Variable to add a filter of the Replace Variable type to a single chart. After you configure the settings of variable replacement on the Common Settings tab, Simple Log Service adds a filter in the upper-left corner of the chart. You can select a value from the filter drop-down list. After you select a value, Simple Log Service automatically replaces the variable in the query statement of the chart 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 Mapping Value section
Parameter
Description
Mapping Value
The text or icon that you want to use to replace a specified value in the table.
For example, if you set Value to 200, Mapping Type to Text, and Mapping Value 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.
Configurations on the Fields 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 information about the parameters on the Fields tab, see Configurations on the Common Settings tab.
For example, in the A > pv section, you can configure settings for the pv field in the results of Query Statement A. The values of the pv field are highlighted after you select Text Highlight from the Column Settings > Cell Display Mode drop-down list and are displayed in different colors based on the specified thresholds.
Drill-down events
You can configure a drill-down event for the results of a single query statement or for a single column of data in the results to analyze data from a finer-grained dimension. Drill-down events include events to open a Logstore, open a saved search, open a dashboard, open trace analysis, open trace details, and customize an HTTP link. For more information, see Drill-down events.
For example, in the A > pv section, you can configure an Open Logstore drill-down event for the pv field in the results of Query Statement A. After you configure the event, you can click a value in the pv column of the table and click Open Logstore. Then, you are navigated to the Logstore that you specify.
