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.

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

Introducing InfluxDB Clustered

A highly available InfluxDB 3.0 cluster on your own infrastructure.

InfluxDB Clustered is a highly available InfluxDB 3.0 cluster built for high write and query workloads on your own infrastructure.

InfluxDB Clustered is currently in limited availability and is only available to a limited group of InfluxData customers. If interested in being part of the limited access group, please contact the InfluxData Sales team.

Learn more
Contact InfluxData Sales

The future of Flux

Flux is going into maintenance mode. You can continue using it as you currently are without any changes to your code.

Flux is going into maintenance mode and will not be supported in InfluxDB 3.0. This was a decision based on the broad demand for SQL and the continued growth and adoption of InfluxQL. We are continuing to support Flux for users in 1.x and 2.x so you can continue using it with no changes to your code. If you are interested in transitioning to InfluxDB 3.0 and want to future-proof your code, we suggest using InfluxQL.

For information about the future of Flux, see the following:

InfluxDB Cloud powered by TSM