Drilling down to a related dashboard

KUMA allows filtering data in widgets of the Events type in the current dashboard and drill down to another dashboard while keeping the configured filtering parameters and period.

This is achieved using global variables. The global variables must be configured in both dashboards, as well as in the properties of widgets: on the target dashboard, the variable is specified in the SQL query, and in the source dashboard, the variable is specified when managing the Drill down to another dashboard setting. When drilling down from one dashboard to another, KUMA automatically substitutes the selected value of the variable and the period, after which the charts in the target dashboard are rebuilt. Both dashboards must be in the same tenant.

Local variables cannot be used when drilling down to another dashboard.

Configuring the target dashboard

To configure the target dashboard:

1. In the KUMA web interface, in the Dashboards section, select a dashboard and create a global variable.

   The variable name may contain only English letters and numerals and may not contain spaces.

2. Save your changes.
3. On the dashboard, select an existing Events widget or click the Add widget button and then select the Events widget type.
4. On the General tab, specify the previously created variable:
   • Under Defined variables
   • In the SQL query field For the SQL query to take into account the value of the variable, add the filter() function to the WHERE clause.

     The syntax for variables with a specific value is as follows:

     filter(<event_field_name> = $variable_name)

     The syntax for variables with an arbitrary value entered manually is as follows:

     filter(<event_field_name> like $variable_name)

     Query example

     Query with a $ServiceName variable:

     SELECT DestinationHostName AS Host, Name AS Status, Message AS Reason, ServiceName, Timestamp AS Time

     FROM events

     WHERE DeviceEventClassID = 'KLSRV_HOST_STATUS_CRITICAL' OR DeviceEventClassID = 'KLSRV_HOST_STATUS_WARNING' AND filter(ServiceName = $ServiceName)

     ORDER BY Time DESC

     LIMIT 25

     If a value is passed in the $ServiceName variable when drilling down to the target dashboard, the value is automatically substituted into the query and the data is filtered. If the value of the variable is not specified, the query is executed as if the variable was not present.

5. Save your changes.

Configuring the source dashboard

To configure the source dashboard:

1. In the KUMA web interface, in the Dashboards section, select a dashboard and create a global variable.

   The variable name must be the same as the name of the variable created in the target dashboard. The name may contain only English letters and numerals and may not contain spaces.

2. Save your changes.
3. On the dashboard, select an existing Events widget or click the Add widget button and then select the Events widget type.
4. On the General tab, in the Defined variables section, specify the previously created variable.
5. On the Actions tab, specify the following settings:
   1. In the Chart segment or Legend item section, enable Drill down to another dashboard.
   2. In the Dashboards drop-down list, select the target dashboard.
   3. In the Value drop-down list, select the variable whose value you want to pass when drilling down to another dashboard. This must be the same variable that you created earlier.

      The selected variable must be specified in the SQL query of the widget on the target dashboard, so that the data on this widget is automatically filtered after the drill-down.

6. Save your changes.

Drilling down from source dashboard to target dashboard

To drill down to the target dashboard:

1. In the KUMA web interface, under Dashboards, select the source dashboard.
2. Find the widget for which you have enabled the Drill down to another dashboard option. Click the segment or item in the legend of the chart for which this action is configured.

   This opens the target dashboard in a new tab. The period of the original widget is automatically applied to the entire dashboard, and the selected value from the Value drop-down list is passed as a variable to widgets of the Event type, in which this variable is used in the SQL query through the filter() function. The charts in the widgets on the other dashboards are rebuilt with the passed values taken into account.

   If you change or delete a variable that is specified in the action on the target dashboard to which you are drilling down to, the drill-down is still performed, but the value of the variable is not passed.

Page top