Skip to main content

Filters

Filters in a dashboard report allow you to personalize and tailor the displayed data according to your needs. You can apply filters to focus on specific aspects of the information and obtain a more precise and relevant view of the data.

This functionality enables you to adjust the data displayed in the report based on specific criteria. When you apply a filter, the dashboard will automatically update the displayed information, showing only the data that meets the selected conditions. The different types of filters are detailed below:

Filter TypeDescription
Default ValuesDefault values that are automatically applied to the filter. This helps set an initial option without the user having to select anything.
BooleanA filter that allows you to select between two options: true or false.
Simple SelectionA filter that allows you to select a single option from a list. Useful when only one choice is needed from several available options.
Multiple SelectionA filter that allows you to select multiple options from a list. It enables the user to select more than one option, facilitating broader analysis.
MandatoryA mandatory filter that requires a selection before proceeding. The user must make a selection for the report to be executed.
CascadingA dependent filter that adjusts based on the selection of another filter. For example, the option selected in one filter may affect the available options in another filter.
TreeA filter based on a hierarchical structure of options. It allows users to navigate through categories or subcategories.
DateA filter that allows you to select a date or a date range. Ideal for filtering by specific time periods. This filter has the following options: On, After, Before, Between, Is Null, Not between, Is not null, This (Days, Weeks, Months, Quarters, Years), Next (Days, Weeks, Months, Quarters, Years), Last (Days, Weeks, Months, Quarters, Years),Today
NumericA filter based on numerical values, allowing comparisons or ranges. Useful for filtering numerical data within a specific range. This filter has the following options: Equal, Less than, Less than or equal, Great than, Great than or equal, Between, Is null, Not equal, Not between, Is not null

By clicking the "Clear" button, all selected filter criteria are removed. To apply this action, click the "Apply" button so that the report reloads with the complete dataset, without any restrictions. This functionality is useful when users want to start over with new filter selections or simply view all the data without any applied filters. It ensures a refreshed view of the report, providing an easy way to reset the filtering options.

How to Apply Filters

To apply filters, first make sure you have the report you want to execute. Then, open your web browser, either Google Chrome or Microsoft Edge. Next, select the Report and drag it into the browser, dropping it in the browser window. Once the report has loaded, select the filters you need, and finally, click the Apply button to load and view the corresponding information.