All Products
Search
Document Center

Simple Log Service:Table (Pro)

Last Updated:Jul 25, 2024

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.

    • 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.

    Items Per Page

    The number of logs displayed per page.

    Sort By

    The table is sorted according to the selected field.

    Sorting Method

    The table is sorted according to the selected method.

    • 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 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.

    Search Mode

    Methods of searching table data:

    • Search: Input values to search.

    • Filter: View by page filtering.

    Multiple Choices

    Whether the table data search supports multiple selection.

    • Multiple-choice

    • Single

    Exact Search

    When the Exact Search switch is turned on, table search only supports exact search.

    Font Size

    The font size of the content in cells.

    Show All

    When the Show All switch is turned on, the values of the fields are fully displayed in the table.

  • 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.

Table (Pro)

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.

Table (Pro)