Table

    Table visualization Table - 图2

    Annotations are not currently supported in the new table panel. This might be added back in a future release.

    Sort column

    Click a column title to change the sort order from default to descending to ascending. Each time you click, the sort order changes to the next option in the cycle. You can only sort by one column at a time.

    Table options

    Show or hide column names imported from your data source.

    By default, Grafana automatically calculates the column width based on the table size and the minimum column width. This field option can override the setting and define the width for all columns in pixels.

    For example, if you enter in the field, then when you click outside the field, all the columns will be set to 100 pixels wide.

    Minimum column width

    By default, the minimum width of the table column is 150 pixels. This field option can override that default and will define the new minimum column width for the table panel in pixels.

    For example, if you enter in the field, then when you click outside the field, all the columns will scale to no smaller than 75 pixels wide.

    For small-screen devices, such as smartphones or tablets, reduce the default pixel value to to allow table based panels to render correctly in dashboards.

    Column alignment

    Choose how Grafana should align cell contents:

    • Auto (default)
    • Left
    • Center
    • Right

    By default, Grafana automatically chooses display settings. You can override the settings by choosing one of the following options to change all fields.

    Color text

    If thresholds are set, then the field text is displayed in the appropriate threshold color.

    Color text Table - 图4

    Color background (gradient or solid)

    If thresholds are set, then the field background is displayed in the appropriate threshold color.

    Color background Table - 图6

    The threshold levels define a gradient.

    Gradient gauge Table - 图8

    LCD gauge

    The gauge is split up in small cells that are lit or unlit.

    LCD gauge Table - 图10

    JSON view

    Shows value formatted as code. If a value is an object the JSON view allowing browsing the JSON object will appear on hover.

    JSON view Table - 图12

    If you have a field value that is an image URL or a base64 encoded image you can configure the table to display it as an image.

    Cell value inspect

    Enables value inspection from table cell. The raw value is presented in a modal window.

    Column filter

    You can temporarily change how column data is displayed. For example, you can order values from highest to lowest or hide specific values. For more information, refer to Filter table columns.

    Use this option to enable or disable pagination. It is a front-end option that does not affect queries. When enabled, the page size automatically adjusts to the height of the table.

    Filter table columns

    If you turn on the Column filter, then you can filter table options.

    Turn on column filtering

    1. In Grafana, navigate to the dashboard with the table with the columns that you want to filter.
    2. On the table panel you want to filter, open the panel editor.
    3. Click the Field tab.
    4. In Table options, turn on the Column filter option.

    A filter icon appears next to each column title.

    Column filtering turned on Table - 图16

    Filter column values

    To filter column values, click the filter (funnel) icon next to a column title. Grafana displays the filter options for that column.

    Filter column values Table - 图18

    Click the check box next to the values that you want to display. Enter text in the search field at the top to show those values in the display so that you can select them rather than scroll to find them.

    Columns with filters applied have a blue funnel displayed next to the title.

    Filtered column Table - 图20