Drilling down to a related dashboard

KUMA allows you to filter data in Event widgets not only within the current dashboard, but also when drilling down to another dashboard. In this case, the selected filtering parameters and the time period are preserved and applied to the new dashboard.

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 configuring the Drill down to another dashboard action. When drilling down from one dashboard to another, KUMA automatically substitutes the selected value of the variable and the time period, after which the charts in the target dashboard are rebuilt.

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

To configure the drill-down from one dashboard to another, you need to configure both dashboards: first the target dashboard, then the source dashboard. Both dashboards must belong to the same tenant.

Configuring the target dashboard

To configure the target dashboard:

1. 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 Available variables
   • In the SQL query field For the SQL query to take into account the value of the variable, you need to 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 to be 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 10

     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 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, specify the previously created variable under Available variables.
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 Dashboards section, select the source dashboard.
2. Find the widget for which you have enabled the Drill down to another dashboard option. Click a segment or legend item of the chart for which this action is set.

   This opens the target dashboard in a new tab. The time 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 it 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