Visualizing data as tables
To configure the BMC Table visualization plug-in
- On the Home page, select Add > Visualization.
- In the Query section, select the data source (for example, BMC Helix) and add your queries.
For instructions, see Creating-a-dashboard. - On the Panel tab, expand Visualizations and select BMC Table.
The BMC Table visualization plug-in is displayed. Expand the tabs and configure these settings.
Panel options
Title and description
Specify a panel title and optional description.
Transparent background
Specify whether you want to use the transparent background for the panel.
Panel links
Add one or more links to navigate to other content.
Repeat options
Select a variable. The panel is created for each variable value.
Important: The panel creation options are not visible in edit mode. To view these options, navigate to the dashboard and update the variable or reload the dashboard.
General options
Show header
Show or hide column names.
Show grid
Show or hide grid lines between the cells.
Show search
Show or remove the search field to be displayed at the top of the table.
Show sort
Show or hide sort icons for each column in the header row.
Footer options
Show footer
Show or hide the total record and pagination displayed below the table.
(Displayed when the show footer option is enabled) Show total rows
Display the total number of rows in the footer.
(Displayed when the show footer option is enabled) Show pagination
Display the pagination in the footer.
Column options
Min width
Specify the minimum width of the columns. The default is 50.
Font size
Specify the font size of the column text.
Coloring
Select a color for the table cell content or background. The default is Auto.
Alignment
Select an alignment for the table content.
Cell options
Cell value inspect
Enable value inspection from a table cell. The raw value is displayed in a modal window.
Cell value tooltip
Enable the tooltip for table cell values.
Cell height
Select a height for the table cells. If you select Dynamic:
- The cell height is adjusted based on the cell content.
- The Autofill height option is displayed. Enable it to automatically adjust the height of rows to fit in the table size.
Standard options
Unit
Select a unit for all fields in the visualization.
Min
Specify the minimum values used in percentage threshold calculations or leave this field empty to calculate these values automatically.
Max
Specify the maximum values used in percentage threshold calculations or leave this field empty to calculate these values automatically.
Field min/max
Enable to calculate the minimum or maximum value of each field separately.
Decimals
Enter the number of decimals to be used in the rendered value.
Display name
Specify the display title of all fields.
Color scheme
Select a color theme for your visualization.
No value
Specify a character to be displayed when a field value is empty or null. The default is - (dash).
Data links
+ Add link
Add a link to navigate to another dashboard.
Value mappings
Add value mappings
Add a value mapping to change how data appears in the visualization. For each value mapping, specify the following options:
- Value: Enter a specific value, a range, or a regular expression to be mapped with the display text.
- Display text: Specify what you want to display as text instead of values.
- (Optional) Color: Change the text color from the color picker.
Thresholds
+ Add threshold
Click Add threshold and specify a threshold value and update the threshold color from the color picker.
The following threshold values are used by default:
- 80 with the red color
- Base with the green color
Thresholds mode
Select a mode for thresholds.
- Absolute: Thresholds are defined by a number. By default, Absolute is selected.
- Percentage: Thresholds are defined relative to the minimum or maximum value; for example, 80 percent.
- (Optional) Click Add field override to configure overrides for fields.
For details, see Adding-overrides-to-fields-in-a-dashboard.