This documentation supports releases of BMC Helix Dashboards up to December 31, 2021. To view the latest version, select the version from the Product version menu.

Visualizing data as grids in panels

As a tenant administrator or an editor, you can use the visualizations BMC Cross-tab visualization to configure dashboards. With this visualization, you can view a grid that shows the relationship between two dashboards. You can use this visualization with the Service-Management-query to fetch data from multiple sources in a single dashboard. As an example, see the out-of-the-box Service-dashboard, which fetches data from BMC Helix Operations Management, BMC Helix ITSM, and BMC Helix AIOps.

For information about configuring dashboards, see Configuring-dashboards-panels-and-queries.

Overrides tab not supported

While using this visualization type, only the All tab is supported. The Overrides tab is not supported.

bmc_cross_tab_all_panel_dec_push.png

  1. Log in to BMC Helix Dashboards.
  2. Hover your mouse over the Create icon create_icon.png and click Dashboard.
  3. Click Add new panel.
  4. In the Query section, select BMC Helix and add your queries. For instructions, see Configuring-dashboards-panels-and-queries.
  5. In the Panel tab, expand Visualization and select BMC Cross-Tab.
    bmc_cross_tab_highlight.png
  6. Expand Display to configure the following:
    • Aggregator type—Select an aggregator type.
    • Show Percentage of the Total row—Click to show or hide percentage.
    • Show Percentage of the Total column—Click to show or hide percentage.
    • Hide empty values—Click to show or hide empty values.
    • Show the Total columns and row—Click to show or hide columns and rows.

    • Configure the pivot categories for the rows and columns.

      How do I configure the fields? Click to read more...

      The fields on the dashboard contain the data that you add in the data fields for a panel.

      For example, the following screenshot displays the pivot categories that are available for a panel:

      categories.png

      You can configure the following for the fields:

      • The fields in columns or rows—Under Pivot Categories, drag and drop fields between the Column fields and Row fields sections to specify the fields to appear in columns and rows. The and Value fields section displays the value of the combination between the columns and rows based on the aggregator type that you selected.
      • The field filters—Under Pivot Categories, use the Field filters section to configure the filters that you want to see for each field on the dashboard. For example, you can select to display the assigned, in progress, and pending events in the Status row, and filter out the closed and cancelled events.
      • The sorting for rows and columns—Under Pivot Categories, use Sort order to display the rows and columns sorted in an ascending or descending order. Select Totals asc or Totals desc to sort the Totals row or column.
  7. (Optional) In the Field tab, configure the custom options and the thresholds for the data.
    Bmc_Cross_tab_field_tab_july2021.png
    Do the following:
    1. Under Custom options, in the Cell display mode field, select an option to choose to color either the background or the text in the panel.
      Select No coloring if you don't want to use colors in the panel.
    2. Under Standard options—Set the following:
      • Unit, Min, and Max—Configure the values as you want to see them in the chart.
      • Decimals—By default, this is set to 0 (Zero) to indicate that there are no decimal points in the X or Y-Axis of the chart. Configure the values as you want to see them in the chart.
      • Display name—Configure the field or series name.
      • No value—Configure what to show when there is no value.
      • Color Scheme—Select color schemes for the chart. 

    3. Under Thresholds, add the thresholds for your data and select a threshold mode.

      How do I determine the threshold mode? Click to read more...

      Select the Percentage threshold mode if you have selected one the following aggregator types in the Panel tab:

      • Sum as Fraction of Total
      • Sum as Fraction of Rows
      • Sum as Fraction of Columns
      • Count as Fraction of Total
      • Count as Fraction of Rows
      • Count as Fraction of Columns

      For all other aggregator types, use the Absolute threshold type.

    4. (Optional) Under Value mappings, configure the following:
      • Mapping type—Select an mapping type.
      • Value—Specify a value for the mapping.
      • Text—Specify the text to display.
    5. (Optional) Under Data Links, configure the following:
      1. Click Add link.
        Add the title and URL.
      2. Choose to open the URL on a new tab or on the same tab.
      3. Save the changes.
  8. Save the panel.