Documentation

Table visualization

The Table option displays the results of queries in a tabular view, which is sometimes easier to analyze than graph views of data.

Table example

Select the Table option from the visualization dropdown in the upper left.

Table behavior

The table visualization renders queried data in structured, easy-to-read tables. Columns and rows match those in the query output. If query results contain multiple tables, only one table is shown at a time. Select other output tables in the far left column of the table visualization. Tables are identified by their group key.

Table Controls

To view Table controls, click Customize next to the visualization dropdown.

Formatting
  • Default Sort Field: Select the default sort field. Default is time.

  • Time Format: Select the time format. Options include:

    • YYYY-MM-DD HH:mm:ss ZZ
    • YYYY-MM-DD hh:mm:ss a ZZ
    • DD/MM/YYYY HH:mm:ss.sss
    • DD/MM/YYYY hh:mm:ss.sss a
    • MM/DD/YYYY HH:mm:ss.sss
    • MM/DD/YYYY hh:mm:ss.sss a
    • YYYY/MM/DD HH:mm:ss
    • YYYY/MM/DD hh:mm:ss a
    • HH:mm
    • hh:mm a
    • HH:mm:ss
    • hh:mm:ss a
    • HH:mm:ss ZZ
    • hh:mm:ss a ZZ
    • HH:mm:ss.sss
    • hh:mm:ss.sss a
    • MMMM D, YYYY HH:mm:ss
    • MMMM D, YYYY hh:mm:ss a
    • dddd, MMMM D, YYYY HH:mm:ss
    • dddd, MMMM D, YYYY hh:mm:ss a

  • Decimal Places: Enter the number of decimal places. Default (empty field) is unlimited.

    • Auto or Custom: Enable or disable auto-setting.
Colorized Thresholds
  • Base Color: Select a base or background color from the selection list.
  • Add a Threshold: Change the color of the table based on the current value.
    • Value is: Enter the value at which the table should appear in the selected color. Choose a color from the dropdown menu next to the value.
Column Settings
  • First Column: Toggle to Fixed to lock the first column so that the listings are always visible. Threshold settings do not apply in the first column when locked.
  • Table Columns:
    • Enter a new name to rename any of the columns.
    • Click the eye icon next to a column to hide it.
    • [additional]: Enter name for each additional column.
    • Change the order of the columns by dragging to the desired position.

Table examples

Tables are helpful when displaying many human-readable metrics in a dashboard such as cluster statistics or log messages.

Human-readable cluster metrics

The following example queries the latest reported memory usage from a cluster of servers.

Query the latest memory usage from each host
from(bucket: "example-bucket")
    |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
    |> filter(fn: (r) => r._measurement == "mem" and r._field == "used_percent")
    |> group(columns: ["host"])
    |> last()
    |> group()
    |> keep(columns: ["_value", "host"])
Cluster metrics in a table
Human readable metrics in a table

Was this page helpful?

Thank you for your feedback!


Select your region

Linux Package Signing Key Rotation

All signed InfluxData Linux packages have been resigned with an updated key. If using Linux, you may need to update your package configuration to continue to download and verify InfluxData software packages.

For more information, see the Linux Package Signing Key Rotation blog post.

InfluxDB Cloud backed by InfluxDB IOx

All InfluxDB Cloud organizations created on or after January 31, 2023 are backed by the new InfluxDB IOx storage engine. Check the right column of your InfluxDB Cloud organization homepage to see which InfluxDB storage engine you’re using.

If powered by IOx, this is the correct documentation.

If powered by TSM, see the TSM-based InfluxDB Cloud documentation.

InfluxDB Cloud backed by InfluxDB TSM

All InfluxDB Cloud organizations created on or after January 31, 2023 are backed by the new InfluxDB IOx storage engine which enables nearly unlimited series cardinality and SQL query support. Check the right column of your InfluxDB Cloud organization homepage to see which InfluxDB storage engine you’re using.

If powered by TSM, this is the correct documentation.

If powered by IOx, see the IOx-based InfluxDB Cloud documentation.

State of the InfluxDB Cloud (IOx) documentation

The new documentation for InfluxDB Cloud backed by InfluxDB IOx is a work in progress. We are adding new information and content almost daily. Thank you for your patience!

If there is specific information you’re looking for, please submit a documentation issue.