Knowi provides a range of Date/Time filters out of the box at the dashboard or widget level.
Usage:
Step 1: Click on the edit icon of the time-based filter.
Step 2: Change the condition type (type of filter) and select any of the following three as the filter controls to define the date range for fetching the value:
-
Date Picker: Set up the date/time range using the picker
-
Range Slider: Set up the date/time range using the slider
-
Date/Time: Set up the date/time range using a slider
For example, you can use Date Picker as a filter control.
Customizing Date Picker Options
If you would like fine-grained control on the filter picklist options for Date/Time-based filters, you can optionally define and configure it via the following steps:
Step 1: Create an Excel/CSV formatted file with the appropriate date options you would like to display. Here is an example:
Modify the Label, Value, and Range appropriately for your use case. For a list of date tokens, refer to Date Tokens.
Step 2: Upload file to Knowi using the Upload File option in the Datasource.
Step 3: Select the auto-suggested values or labels or both (from the dropdown list) from this new dataset in the filter, set the appropriate field. From the example above: if it is a date range, the Value will be Range, Label will be the Label field. For greater than/less than etc, Value will be Value, Label will be Label.
Step 5: Once saved, your picklist should now show the applicable values from the new dataset.
You can also customize the picklist for the Last N Period or Custom date.
Usage:
Step 1: Select the filter type (anything except range) and the specific time for which you want to filter the values. You can also select Last N Period or Custom date among many other options from the dropdown list while specifying the time.
After making the relevant selection, toggle on the auto-suggestions and select another dataset from which you would like to pick the auto-suggested values. Select the auto-suggested values or labels or both (from the dropdown list) you want to fetch from another dataset through the filter picklist and click on the Save.
Step 2: Navigate to the dashboard, click on the filter configured for auto-suggestions to pick the values automatically suggested from another dataset you have selected.
Note: The last two options in the picklist will always be available-
-
Last N Period
-
Custom
Step 3: Make the selection from the picklist, click on Apply, and the results in the dataset shall be updated accordingly.