Configure global filters ↗

Define global filters on your dashboards to enable users to alter the scope of the data by selecting from predefined or dynamic values. You can define filters using free text, single-select, or multi-select input values. Once configured, these filters are accessible to anyone viewing the dashboard.

You can configure up to four global filters on a single dashboard or report.

Prerequisite: Before configuring global filters, you must add parameters to one or more custom XQL widgets on your dashboard. For more information, see Add parameters to a custom XQL widget.

Open the dashboard builder.

Select a dashboard from the Dashboard Manager and click Edit.

Open the filter configuration.

In the Widget Library click the Filters & Inputs icon.

Define the Input name.

Enter a name that identifies the parameter for dashboard users.

Select the filter type.

Choose one of the following options:

  • Single Select: To specify a single predefined value.

  • Multi Select: To specify multiple predefined or dynamic values.

    Note: Multi-select and dynamic filters require the IN operator to be configured within the XQL widget query.

  • Free text/number: To specify a single free-text value.

Select the parameter.

From the dropdown, choose the specific parameter from your XQL widgets that you want to configure.

Define dropdown options.

For Single Select or Multi Select filters, specify filter values. When the dashboard is generated, these options will appear in a dropdown list.

  • For Predefined inputs: Manually type the list values.

    Guidelines for predefined inputs

    • The values must support the parameter type. For example, specify characters for $name and numbers for $num.
    • If you uploaded numbers in a string, enclose each number in quotes (e.g., "500").

  • For Dynamic inputs: Configure a query to fetch dynamic values. Click Select under Define Query.

    Guidelines for dynamic inputs

    • The query must include the fields stage to select the specific column name for the dropdown values. All values in this field will be available for selection and will update dynamically.

    • Example:
      In this example, the endpoint_name field is configured so users can filter by one or more endpoint names:
      dataset = endpoints | fields endpoint_name

    • Note: If you specify more than one field, only the first field's values will be used.

(Optional) Define a default value.

If you define a default, the widget populates automatically when the dashboard opens. If no default value is defined, the user can select a value when they open the dashboard.