Mandatory Date Range Filter
Description
This filter control is commonly used to filter datasets based on a specific field identified in the Filter
property. This is a single-field filter that allows date range selection, which includes both start and end dates. One date picker is provided for each. When the control is enabled, both From
and To
fields applied. This is suitable for date and datetime field types (field identified for Filter
).
Viewer Usage
There are two input fields available. The From
date picker allows selection of the lower boundary or start date while the To
date picker allows selection of the upper boundary or end date. The values are inclusive.
To open the date picker, click on the date picker button corresponding the field.
Number | Description |
---|---|
1 | Navigates to the previous year and updates the displayed calendar accordingly. |
2 | Navigates to the next year and updates the displayed calendar accordingly. |
3 | Navigates to the previous month and updates the displayed calendar accordingly. |
4 | Navigates to the next month and updates the displayed calendar accordingly. |
5 | Clicking on any day on the displayed calendar sets the field value to the selected date and closed the date picker. The selected value is reflected on the displayed date label. |
If no Initial Value
is set for the control, the From
date is set on the first day of the current year in local time by default while the To
date is set on the current date in local time.
The range of each date picker is dependent on the other. The From
date cannot be later than the To
date and the To
date cannot be earlier than the From
date. The most recent date that can be selected on the From
date picker is the current value set for the To
date. Likewise, the earliest date that can be selected on the To
date picker is the current value set for the From
date.
Specific Properties
Below are the fields that are specific to this control:
Field | Description | Mandatory | Input Type | Constraints | Default Value |
---|---|---|---|---|---|
Initial Values | Determines the initial set or selected values upon loading in the Dashboard Viewer. | Y | Select | 1 value can be selected. Available options are: - None From: First day of the current year in local time To: Current day in local time - Today From: Current day in local time To: Current day in local time - Last Week From: Today in local time minus 6 days To: Current day in local time - Last Month From: Current day in local time minus 1 month plus 1 day To: Current day in local time - Last Quarter From: Current day in local time minus 3 months plus 1 day To: Current day in local time - Last 6 Months From: Current day in local time minus 6 months plus 1 day To: Current day in local time - Last Year From: Current day in local time minus 1 year plus 1 day To: Current day in local time |
“None” |