Using the BMC Cross-tab visualization to build 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 Incident Management, 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 Panel and Field tabs are supported. The Overrides tab is not supported.

  1. Log in to BMC Helix Dashboards.
  2. Hover your mouse over the Create icon  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.
  6. Expand Display and do the following:
    • Select an aggregator type.
      Aggregator types are the types of available calculations for the values to be displayed in the panel.
    • Choose to display or hide the Totals column.
    • Configure the pivot categories for the rows and columns.

       How do I configure the fields? Click to

      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:

      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.

    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 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.

  8. Save the panel.
Was this page helpful? Yes No Submitting... Thank you