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: Select the Condition Type
Greater Than: Includes only dates after the specified date (e.g., greater than July 1 returns results from July 2 onward).
Range: Includes all dates between a start and end date, usually inclusive (e.g., July 1 to July 5 includes all five days).
Equals: Matches a single exact date (e.g., only returns results from July 1).
Not Equals: Excludes a specific date (e.g., returns all dates except July 1).
- Greater Than: Includes only dates after the specified date (e.g., greater than July 1 returns results from July 2 onward).
Greater Than or Equals: Includes the specified date and any date after it (e.g., from July 1 onward).
Less Than: Includes only dates before the specified date (e.g., anything before July 1).
Less Than or Equals: Includes the specified date and any date before it (e.g., July 1 and earlier).
Is Null: Returns results where the date field is empty or missing.
Is Not Null: Returns results where the date field has any value.
Step 3: Configure the Date Range Filter
Choose one of the following filter controls to define the date range for fetching values:
Date Picker: Define the date/time range using a calendar or by selecting from a list of predefined time frames (e.g., Today, Yesterday, This Week, Last 90 Days, etc.). These drop down options can be customized, refer to the section Customizing Date Picker Options" below.
Range Slider: Define a continuous date/time range using an interactive slider.
Date/Time: Specify the date using a calendar and input the start and end times in 24-hour format. By default, the selected time applies to each day within the date range (e.g., 09:00–17:00 daily). When the "Continuous Time" toggle is enabled, the selected time range is treated as continuous, starting from the chosen start date and time (inclusive) and ending at the selected end date and time (exclusive). For example, a range from 09:00 Monday to 17:00 Friday will include every hour within that period. Any runtime parameters used as filters will automatically require continuous time to be enabled.
Date Filter Range Limits
This setting defines the maximum allowable length of a date range that an end user can select when using a date filter. Administrators can also control which direction in time is selectable and anchor the limit to a fixed reference point rather than to wherever the user clicks.
Behavior based on filter Condition type:
- Range: Limits the total span of dates that a user can select.
- Equals: Restricts the selectable date range based on an offset from a reference point. The user can only select a date that falls within the specified limit.
Date Unit and Value
Set the maximum span using a numeric value and a unit (Days, Weeks, Months, or Years). The Value field also accepts $c9_ date tokens (e.g. $c9_thisweek-1m).
Range Restriction
Controls which direction in time is available for selection:
- Both Future and Past (default) - the user can select dates before or after the reference point, up to the configured limit.
- In The Future - only dates after the reference point are selectable.
- In The Past - only dates before the reference point are selectable.
From
By default, the range limit is applied relative to the date the user clicks in the calendar. Setting an anchor date changes the reference point to a fixed value, and the calendar is centered around it when it opens.
Available anchor options:
- Today
- Yesterday
- This Week
- This Month
- Last 7 Days
- Last 30 Days
- This Quarter
- Last 90 Days
- This Year
- Last Year
-
Custom - enter a date string in your configured date format, or any $c9_ date token (e.g.
$c9_thisweek-1m).
If no From value is set, the calendar continues to apply the limit relative to the date the user clicks.
For example, with Range Restriction set to In The Future, From set to Today, and a limit of 7 Days, the calendar opens with only the next 7 days selectable and all other dates blocked off:
This setting helps administrators enforce constraints on date selections to ensure consistency and prevent excessively broad queries.
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.