Creating dashboards with advanced functions

As a tenant 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 create custom advanced functions for your dashboards.   

Related topics

Configuring-dashboards-panels-and-queries

Creating-custom-dashboards

Supported-database-functions

Out-of-the-box advanced functions

The following table lists the out-of-the-box advanced functions that can be configured by using the Transform option in BMC Helix Dashboards:


To create dashboards with custom advanced functions

You can create custom 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 list, click Add field from calculation to add the incident numbers.

advanced_dashboards_functions_22_2_01_latest.png

The following table lists the custom advanced functions that can be configured by using BMC Helix Dashboards:

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*