Creating dashboards with advanced functions

As an administrator or editor, create dashboards by using advanced functions. You can use these functions to filter the column values in ascending or descending order, calculate the difference in values of two columns and so on. 

BMC Helix Dashboards provides a set of out-of-the-box advanced functions. However, you can also use the existing capabilities of BMC Helix Dashboards to configure a set of advanced functions for your dashboards.

Related topics

Creating-and-customizing-dashboards
Supported-database-functions

Out-of-the-box advanced functions

To access the Advanced functions:

  1. Open the dashboard that you want to edit.
  2. Click the title bar of the panel that you want to edit.
  3. Select Transform data > Advanced functions.

image-2024-7-1_15-39-20.png

The following table lists the out-of-the-box advanced functions that can be configured:


To create dashboards with configurable advanced functions

You can configure advanced functions by using BMC Helix Dashboards. Let's say you are a tenant administrator who wants to calculate the sum of the incident numbers for the most recent month. From the Transform data list, click Add field from calculation to add the incident numbers.

image-2024-7-1_15-38-7.png

The following table lists the set of configurable advanced functions:

The following table describes how to interpret the DBFN functionalities mentioned in the above SQL queries:

 

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