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.
Date Filtering
Similarly, Knowi supports date filters for Date fields on a Widget or Dashboard level. To add/edit a date filter:
1. Navigate to Filters on a widget and click Add.
2. In the Field to Filter, choose Date.
3. In the Condition Type, choose any conditions according to the use case, like equals, greater than, etc.
4. In the Value Type, choose any of the values according to the use case, like today, this quarter, etc
5. Click Save.
Note: When users choose the condition type as Equals on a date filter, there is an option to filter based on the Last N Period. This means users can filter data based on the last N period from today. Where N could be minutes, days, months, or years.