Configure table widgets for modern dashboards
This topic applies to all Orion Platform products.
Table widgets display data or information in a tidy grid format. You can use them on modern dashboards.
Orion Platform 2020.2.5 updates for table widgets
Options to search and sort data
Options to customize how often data is refreshed
If the table contains too many rows, only the visible ones are loaded to improve the performance. Once you hover over the table widget, a scroll bar is displayed and additional rows are loaded as you scroll down.
How to configure table widgets
- Specify the title and other details for the widget.
- Define data to be displayed.
- Customize columns for the table: click Add new column.
- Customize sorting and add search bar (optional, done in Presentation).
- Save Changes.
See Edit widgets for details on resizing widgets, changing widget position, or deleting widgets.
Step 1: Specify the title and other details for the widget
In Presentation, expand Title and description.
Provide the title and subtitle.
If you want to have a link with more details on the widget, provide it in the Widget link URL.
You can also provide a description that might help others to reuse the widget.
Starting with Orion Platform 2020.2.5, you can also set how often you want data in the widget to refresh. See Refresh rate.
Step 2: Define the data to be displayed
Expand Data and Calculations.
Select Use the graphical query builder and click Edit.
Select the entity you want to display metrics for and click Next.
Drag columns that contain the raw data you want to see in the widget.
To display entities with specific values for one of the defined columns, click Add a filter and specify the values to be included.
See your current settings in the Model preview.
When you are satisfied with the preview, click Save model. Your settings are displayed in the data model and in the widget preview.
Select Hand-edit a SWQL Query and click Edit.
Copy the following query into the SWQL query field and click Save model.Copy
Select top 25 events (SWQL)
SELECT TOP 25 COUNT(e.EventID) as value, t.Name as type
FROM Orion.Events e JOIN Orion.EventTypes t ON e.EventType = t.EventType
GROUP BY type ORDER BY value DESC
The scripts are not supported under any SolarWinds support program or service. The scripts are provided AS IS without warranty of any kind. SolarWinds further disclaims all warranties including, without limitation, any implied warranties of merchantability or of fitness for a particular purpose. The risk arising out of the use or performance of the scripts and documentation stays with you. In no event shall SolarWinds or anyone else involved in the creation, production, or delivery of the scripts be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the scripts or documentation.
Starting with 2020.2.5, columns mentioned in the Data model section are added automatically.
To add columns:
- Click Add new column.
- Expand Description and provide the label for the column. You can also specify a fixed width for the column or hide the column.
- Expand Property and formatting and specify the format for displayed data:
- When finished, save the changes.
Starting with Orion Platform 2020.2.5, you can define sorting and add a search box for your table.
By default, the table is sorted by the value in the first column, in ascending order.
In Presentation, expand Sorting, and select the column to sort by in the drop-down.
The values in the drop-down are labels you specified for your columns.
To sort in descending order, select the Descending box.
Add a search box for the table widget
In Presentation, expand Search, and switch on the Enable toggle. This adds a search box at the top of the table widget. You search for data displayed in any of the columns.