Data Tables

Create a data table in Custom Dashboards to visualize logs, metrics, or spans.

Create a data table

STEP 1. In Custom Dashboards, drag and drop the data table widget from your left-hand side bar to get started.

STEP 2. Build a query using Query Builder.

STEP 3. Define the query parameters in the left-hand panel and click SAVE.

Logs and spans-based widgets

Table type

When using logs or spans as the data source, you can choose between the Events and Aggregated view.

Events view presents a table with a list of logs or spans ordered by time (you can change this to be sorted by other columns later) with additional metadata and labels relevant to those events, similar to the view you see in the Explore screen.
Aggregation view presents a table of values, grouped by a field or fields you specify. Each column represents a different value depending on the chosen group. Values could be a simple count or an average of the values for the specific field, for each of the defined group-by values. Add and edit columns and filters for the aggregation table using the right-hand side bar.

Note: Spans are currently limited to a single aggregation column per table widget.

Columns

Manage columns by selecting one or more relevant fields.

Advanced settings

Select the number of results to be displayed per page.

Metrics-based widgets

When setting up a table widget with metrics as the data source in Query Builder, you can select either an instant or range query. The query is executed over a specific timeframe, defined by the dashboard time picker or the widget timeframe. Your choice of query determines how the data is visualized.

Instant query

Instant query mode displays the metric's value at a single point in time, specifically at the end timestamp of the selected timeframe. This mode is ideal for real-time monitoring, providing a snapshot of data at the moment of visualization. It is also more performant, retrieving only the most recent data point without fetching the entire dataset.

Range query

Range query mode retrieves and aggregates metric data over a specified timeframe. It returns all data points between the start and end timestamps that match your query. As the timeframe changes, the system automatically adjusts the interval to optimize the number of data points displayed in the graph.

Data is visualized as a time series graph, showing trends for the selected metric over time. The table widget displays aggregated values derived from the time series data in each corresponding row. For example, the "Max" column for a row shows the highest value from the time series for that specific row.

This mode is well-suited for identifying trends or evaluating performance over a defined period.

Aggregation types

In range query mode, data is aggregated using various methods, each offering a different perspective on the data for the selected timeframe.

Aggregation type	Description
Last	Displays the most recent value within the selected time range.
Min	Shows the smallest value recorded during the time range.
Max	Displays the largest value recorded during the time range.
Avg	Calculates and displays the average of all data points.
Sum	Computes and shows the total sum of all data points.

Limitations

The data table widget is limited to 500 rows. Aggregated values are based on this sample data only.

Support

Need help?

Our world-class customer success team is available 24/7 to walk you through your setup and answer any questions that may come up.

Feel free to reach out to us via our in-app chat or by sending us an email at [email protected].

Line Charts

Next Legend Configuration for Widgets