Filtering widget data
KUMA allows you to filter data in widgets of the Event type by selecting filtering parameters in the dashboard. You can filter data in the following cases:
- Filtering data on a single widget
For this type of filtering, you need to specify one or more local variables in the SQL query in widget properties. Variables allow you to modify this SQL query by substituting the data from the widget on the dashboard into the query. The widget filters the data based on the new values of the variables and refreshes the chart. You do not need to manually change the SQL query in the properties of the widget.
You can apply local variables by clicking the funnel icon (
) in the widget. This opens a window in which you can select or enter values for local variables. - Filtering data in multiple widgets within the same dashboard
For this type of filtering, you need to specify one or more global variables in dashboard properties. Then add global variables to the SQL queries of the widgets to which you want to apply these global variables. When you assign a new value to a global variable, all widgets that use this variable automatically rebuild charts based on the new value.
Global variables are applied by clicking on a segment of the chart or on text from the legend of the chart. KUMA displays a menu with commands that apply the data category of the selected chart segment or plot legend item to a variable.
- Drilling down to another dashboard while passing filtering parameters
Global variables can be used to pass values to another dashboard. When drilling down from one dashboard to another, KUMA substitutes the selected value of the variable and the selected time period, and the charts on the new dashboard are automatically rebuilt.
Local variables cannot be used when drilling down to another dashboard.
We do not recommend setting more than five variables within a dashboard. This can lead to unstable operation of the dashboard.