Panels > Data Table
A Data Table is a way to show information in a table. It’s useful for displaying data over time and across different groups. For instance, you can use it to display the top 10 servers with the highest CPU usage.
The Data Table visualization allows you to view basic information about a selected metric for a given data source for a specified time. A data-table visualization lets you display data from a metric set using a tabular view. Some key features of data-table visualization are as follows:
To create the Data Table
(Refer to Dashboard Creation > Query)
On the right side of the default screen, select Visualization as Table to create an Data Table panel.
There are multiple options to edit the properties of the panel. The first one is Panel Options. Enter a Name and Description for the Panel that you want to create. For instance, if you’re making a Data Table to track CPU usage, name the panel “Data Table” and describe it as “CPU Usage.”
The Description is available in the top left corner and can be viewed by hovering over the i button.
The next part of Panel Options is Panel Link where you can point a link to any other website or dashboard of your choice. Enter a title, and URL, and select the ‘Open in a new Tab’ option if you want to open the link in a new tab. Click Save.
The URL can be a link to another dashboard or for getting help or useful info. When you click on a panel, it opens the link either in the same tab or a new tab, depending on your choices. For example, if you want to compare a default dashboard, just click the link to open it.
The Table options allow you to change the configuration of the table and it includes:
To display the table’s header or not.
To display the table’s footer or not.
This is applicable only when “Show Footer” is enabled. Whichever reducer function we select that value will be added as a footer as a separate row.
You can choose a reducer function for calculation such as Last, First, Max, Min, Mean, Average, Total, Count, Range, Delta, Step, Difference, All Zero, All Null, Difference Percent, and All Values.
Select the Field that you want to calculate.
The minimum width for column auto-resizing.
The total column width.
The type of alignment for the column values includes the following options:
It allows you to configure the color text, and background, show it as a gauge, etc.
This will enable the filter for each column present in the Table.
You can enable or disable the filters in a table.
The Standard Options are used to configure the other standard settings in the table. It changes the way the table appears.
The further options include:
The Data Links option is similar to the Panel Link where you can link a URL and then open it in another tab. It is placed on the data instead of the Panel.
You can click on the data anywhere and the link option will appear.
It is used for an instant link that you want to appear anytime you click on the data.
The Value Mappings option allows you to find a certain value and wherever the value lies, the display text is displayed. If there is a similar value in the data, it highlights in the form of the color selected.
The Threshold option is used to define the value threshold. You can set certain thresholds and color-code them.
There are two options to show thresholds mode:
For example, CPU usage is set as red for 50, yellow for 60, and blue for 70, that way you can easily see when the output is above the threshold and immediate action can be taken or an error alert can be sent out.
Use the Add field Override option to modify existing fields. Overrides allow you to change the settings for one or more fields. Field options for overrides are the same as the field options available in a particular panel. The only difference is that you choose which fields to apply them to.
To add a field override, click on the Add Field Override button.
Select the Field type
Select a field type, based on the following properties:
You can add multiple fields overrides by repeating the same.
You have now learned how to configure the Data Table, change the panel settings, and more. You can save and edit the panel later too.
A Data Table is used to display information in a tabular format, making it easy to view data over time and across different groups. For example, you can use it to show the top 10 servers with the highest CPU usage. For more details, refer to the Data Table page.
To create a Data Table, you need to create a new dashboard panel, configure the query, and select the appropriate data source. Then, choose ‘Table’ as the visualization type. Detailed steps can be found here.
You can rename your Data Table panel and add a description by accessing the Panel Options. Enter a name and description in the provided fields. For detailed instructions, see the Panel Options section.
You can customize your Data Table’s appearance through the Table Options. This includes changing column alignment, showing/hiding headers and footers, and setting column widths. More information is available here.
Use the Value Mappings option to apply color coding to specific values. This feature highlights values with selected colors for easy identification. Learn more about configuring this here.
Use the Thresholds option to define value thresholds and apply color coding. This helps in identifying when a metric crosses a certain value. Detailed guidance is available here.
Check your Table Options and ensure that column widths and alignments are properly set. You may also want to review your Field Overrides and Standard Options settings.
Browse through our resources to learn how you can accelerate digital transformation within your organisation.
VuNet’s Business-Centric Observability platform, vuSmartMaps™ seamlessly links IT performance to business metrics and business journey performance. It empowers SRE and IT Ops teams to improve service success rates and transaction response times, while simultaneously providing business teams with critical, real-time insights. This enables faster incident detection and response.