The Table option displays the results of queries in a tabular view, which is sometimes easier to analyze than graph views of data.
Select the Table option from the visualization dropdown in the upper right.
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.
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:
MMMM D, YYYY HH:mm:ss
dddd, MMMM D, YYYY HH:mm:ss
- Decimal Places: Enter the number of decimal places. Default (empty field) is unlimited.
- Auto or Custom: Enable or disable auto-setting.
- 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.
- 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.
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
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for InfluxDB and this documentation. To find support or submit feedback, the following resources are available:
- Post in the InfluxData Community.
- Submit documentation issues to the InfluxDB 2.0 documentation repository.
- Submit InfluxDB issues to the InfluxDB repository.
For our InfluxDB Cloud customers, InfluxData Support is also available.