Visualizing data as tables


As a reporting editor or administrator, use the BMC Table visualization to visualize data in tables.

Best practice
If you already have dashboards configured by using the Table visualization, we recommend configuring these dashboards again by using the BMC Table visualization, which offers better capabilities and features.

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.

    bmc_table_plug-in.png

  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.

    (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.
  5. (Optional) Click Add field override to configure overrides for fields.
    For details, see Adding-overrides-to-fields-in-a-dashboard.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*