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).
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 a query is displayed in the table. Fixed Time If you turn on Fixed Time, the time range of a 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 of 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 by specifying 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 specify the number of rows to display on each page by specifying Items Per Page.
- Contour: The table is displayed on one page. You can specify the height of rows to display on one page by specifying Row Height.
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, 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 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.
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.
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.