Visualizing data as tables

To configure the BMC Table visualization plug-in

1. On the Home page, select Add > Visualization.
2. In the Query section, select the data source (for example, BMC Helix) and add your queries.
   For instructions, see Creating-a-dashboard.
3. On the Panel tab, expand Visualizations and select BMC Table.
   The BMC Table visualization plug-in is displayed.
   
   
    

4. 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. Important The footer appears on the dashboard, but when a standard unit is applied, the footer does not appear in the exported XLS file Avoid applying a standard unit to display the footer in the exported XLS file.
   (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.
   (Displayed when the show footer option is enabled)  Calculation	Specify the type of calculation that you want to see in the footer, such as: - Count Mean Max Min Median​​​​​​ Total
   (Displayed when the show footer option is enabled)  Fields	Specify the field for which you want to see the calculation 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. Choose from Dynamic, Small, Normal, or Large display options to view the data without line breaks. The default is Small. 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.

5. (Optional) Click Add field override to configure overrides for fields.
   For details, see Adding-overrides-to-fields-in-a-dashboard.

To generate a barcode for a table column

Configure an override to generate a barcode for a table column. The PDF output of the dashboard displays this barcode. You can use it for a specific use case; for example, scan your physical assets such as laptops, generate the barcode of the scanned data, and affix the printed barcode labels to the assets.

We recommend configuring the barcode generation for a single table column only. A maximum of 15 characters are supported in the barcode.

1. On the Overrides tab, click Add field override.
2. From the Fields with name list, select the column for which you want to generate the barcode.
3. Click Add override property.
   
   
    
4. Select Column options > Type > Barcode.
   
   
    
5. Save the changes.
6. (Optional) Download the dashboard in PDF format.
   For details, see Sharing-and-embedding-dashboards.

To hide columns in tables

Configure an override to hide table columns. Use this configuration to analyze the subset of tabular data, which saves you the time to analyze data and draw meaningful insights.

1. On the Overrides tab, click Add field override.
2. From the Fields with name list, select the column that you want to hide.
3. Click Add override property.
   
4. In the Column options, use the toggle key to hide table column.
   
5. Save the changes.
6. (Optional) Repeat these steps to hide more columns.
7. (Optional) Download the dashboard in Excel format.
   For details, see Sharing-and-embedding-dashboards.