Configuring Widget Filters Course
In this course you will learn how to configure widget Filters with the following features
- Configuring Filter for Measure Column
- Configuring Filter for Dimension Column
- Item-based Filtering
- Condition-based Filtering
- Rank-based Filtering
- Filtering based on Relative Dates
Show me how
Configuring Filter for Measure Column
Filter for measure column can be configured through opening the Measure Filter dialog from the Filter option in the Settings drop down menu.
Measure Filter dialog will open like below on clicking the Edit… menu item.
Configure the compare operator and the value to be compared against the selected column values like below.
Click Reset to reset the changes made in the dialog. Doing so, will reset the filter applied to that column before.
Reset will be in enabled state only when there was a filter applied already. Apply will be in enabled state only when there are pending changes in the dialog to save.
To clear the filter applied to a measure column, click the Clear menu item in the Settings drop down menu like below.
Through this filtering, you can filter out the specific items from consideration.
In the example below I just want the 3 last minutes. So I select the 3 last minutes with include selected and click apply, then click OK libe below.
Through this filtering, you can impose a condition based on which the filter need to be applied. This filtering option is disabled, by default. You can enable it by clicking the Condition checkbox. Doing again, will disable it.
In this example let’s apply a condition for the SUM values less than 2500 like below.
Through this filtering, you can filter top or bottom n items based on a different column with the selected aggregated calculation applied. You can enable it by clicking the Rank checkbox. Doing again, will disable it.
In this example , let’s apply a rank filter for 3 values based on date by TOP mode like below.
When all these three filters were configured and applied, the records satisfying the criteria of all these filters will be considered by widget into it.
Filtering based on Relative Dates
This filtering is applicable only for date time type dimension columns. This is an added option for date time columns and hence can be found only for them in Settings drop down menu
Click the Relative Date Filter… option in Settings drop down menu corresponding to that date time column, to open the Relative Date Filter dialog.
In this example let’s apply a filter for the last hour like below
If you use a Microsoft SQL Server or an Oracle Database Data Source:
The relative dates filtering is based on the Server time zone from where you fetched the data.
You can even pin the relative date filter to a specific date such that, it will then behave statically like other normal filters. i.e. last 1 month returns the period w.r.t the specific date such that, it always return the data of the same month even after 1 month.
You can see the preview date (highlighted below) in the dialog based on the values you set.