Filters

All the predefined dashboards include a set of predefined filters. You cannot add filters or edit the predefined filters in a predefined dashboard. However, you can create a custom dashboard and add predefined filters or edit filters.

To apply a predefined filter to a dashboard,

1. Open the dashboard and click the right-arrow icon on the far-left side of the page to expand the Filters sidebar.

2. Select from the available options for each filter. If you are selecting the time range filter, click Apply.

3. Click Apply Filters. The charts in the dashboard are refreshed to show the data based on the applied filters.

Adding filters to a dashboard

If you have created your own dashboard, you can add filters to the dashboard using the Filters panel.

To add a filter to a custom dashboard,

1. Open a dashboard and click + Add/Edit Filters in the left pane. The Add and edit filters configuration pop-up window is displayed.

2. In the pop-up window, you can edit the existing User search and Time range filters or click +Add filters and dividers > Filter to create a new filter.

Use dividers to group similar filters under a category heading.

3. In the Settings tab, select a Filter Type. The Settings options vary depending on the type of filter you select. Filter configurations are available for all filter types, except the Time Range.

Selecting a Filter Type

You can choose one of the following filter types.

Value: The Value filter type creates a drop-down menu on the dashboard. When you select this filter type, you can choose the associated value in the Column field. For example, the User search filter has a column value source.local_user_name that populates the list of local usernames in the filter's drop-down menu.

Numerical range: The Numerical range filter type creates a slider on the dashboard. You can choose from a range of numeric values. For example, when you select the Column value as source.data_size , you can apply the filter based on the range of data in bytes.

Time range: The Time range filter type creates a button on the dashboard. You can set a default time range for the filter such as Last month. When you click on the button, the Edit time range pop-up window is displayed.

Time column: The Time column filter type creates a drop-down menu on the dashboard. This filter type can be used to define a universal time attribute for all the charts in the dashboard. This filter type is useful if you have individual time attributes defined at the chart level and you want to filter based on a single time attribute. You can select different time attributes from the drop-down menu such as local_time , source.local_time , destination.local_time .

Time grain: The Time grain filter type creates a drop-down menu on the dashboard. You can use this filter to view granular data in the charts for the selected time range. For example, if the time range is set to Last month, then the data in the charts are displayed for each day of the last month. By default, the time grain in the charts is set to Day. You can select a different time grain to view the same data by the second, minute, hour, week, month, quarter, year, etc., depending on the selected time range.

4. Next, enter a filter name.

5. If applicable, select from the available filter configuration options.

Selecting Filter Configurations

The following configuration options are available. Values are dependent on other filters: This option is available when you select the Value filter type. You can enable this setting to create a relationship between Value type filters. In the example screenshot, we've created a "User search" filter that depends on the "User group" filter. The user search options are limited based on the user group you select.

Pre-filter available values: This option is available when you select the Value or Numerical range filter types. The pre-filter can be used to populate a refined list of values in the filter's drop-down menu. For example, the Column value source.local_user_name populates a list of all the local usernames. You can apply a simple pre-filter such as source.local_groups.name = `Domain Admins` creating a pre-filtered list of local usernames that are part of the "Domain Admins" user group. You can also click on the Custom SQL tab and define a pre-filter using a custom SQL query.

Sort filter values: This option is available for all filter types, except the Time range. You can sort the outcome of the filter in ascending or descending order. If you are using the Value filter type, you can additionally select a metric to sort the dataset.

Single value: This option is available when you select the Numerical range filter type. You can set a limit on the numerical value or range when selecting the numerical range filter.

The following options are available.

Minimum: Select this option to set the starting number for the range. The numerical range filter will have a single anchor point on the slider where you can set the minimum number as shown in the screenshot. The filter is applied to all charts where the data sizes are greater than or equal to 5.15B.

Exact: Select this option to set an exact number. The numerical range filter will have a single anchor point on the slider where you can set the exact number as shown in the screenshot. The filter is applied to all charts that match the data sizes equal to 5.15B.

Maximum: Select this option to set the ending number for the range. The numerical range filter will have a single anchor point on the slider where you can set the maximum number as shown in the screenshot. The filter is applied to all charts where the data sizes are less than or equal to 5.15B.

6. Include a description of the filter that explains its purpose. When you add a filter description, a tooltip is included beside the filter.

7. Apply filter settings to manage the filter values.

Managing Filter Values

The following filter settings are available.

Filter has default value: Select this option to set default values for the filter based on the values available from the selected Column.

Filter value is required: Select this option to enforce the use of a default filter value. The user must provide a default value before applying the filter.

Select first filter value by default: This option is only available for the Value filter type. When this option is selected, the filter will automatically set the first value in a column's data as the default filter value. You cannot manually set a value under "Filter has default value".

Can select multiple values: This option is only available for the Value filter type. Select this option to enable multiple value selections in "Filter has default value".

Dynamically search all filter values: This option is only available for the Value filter type. Select this option to enable dynamic searching of filter values. If you have large data sets, then this option will match the text as you type in the filter text box and improve the process of selecting values.

Inverse selection: This option is only available for the Value filter type. Select this option to exclude the value you specify in your filter. For example, the screenshot below shows the destination app filter where Dropbox is the selected value. When this filter is applied, then all values except Dropbox will be displayed on the dashboard.

8. Select the Scoping tab to control the charts to which you want to apply the filter. By default, the filter is applied to all charts. If you want to apply

the filter to specific charts, select Apply to specific panels and then deselect the charts you want to exclude from the filter.

9. When finished, click Save.