Date Filtering with Anchor Date Option
Date Filtering with Anchor Date Option
This option enables filtering
on a Date column starting from a specific date. It is supported across Global,
Page, and Widget level filters.
You can find this option
under the Date Filter options, as shown below:
When the Enable Anchor
Date option is disabled (toggle turned OFF), the date-based
filtering is applied relative to the current date. This behavior is
applicable for options like Now, In Last, and Due in Next.
To filter data based on a
specific reference date, you can enable the Anchor Date option by
turning ON the toggle switch next to "Enable Anchor Date".
Once enabled, the following
configuration options are displayed:
- Include Anchor Date:
This option is provided with a toggle switch. When enabled, it ensures that the
entered Anchor Date is included in the filtered results.
- Anchor Date:
Displayed with an input box using the placeholder format dd-mm-yyyy, this field allows users to manually enter or select a date. A calendar icon is also available for easy selection of the required Anchor Date.
The Anchor Date setting is applicable
for filtering options such as Now, In Last, and Due in Next.
These are displayed below the Anchor Date section, separated by a divider.
Additionally, options like Between and In Range can also be
configured if needed.
Example:
Suppose the dataset contains data for the year 1959, covering all 12
months.
When applied, the filter will adjust the chart to display the corresponding data
across all 365 days based on the
Anchor Date and selected filter criteria.
The Anchor date option is configured for Now option:
On Applying the changes, the chart data for all charts get filtered and
displayed as:
Filter configured with In Last option as below:
The filtered data includes the Anchor Date and filters data for Last 5 days
from that date and shows data as below:
Filter options configured with ‘Include Anchor Date’ option toggle turned
OFF:
This configuration removes the Anchor Date from the filtered data and other
date is added as per ‘In Last’ option and data is displayed as below.
The option ‘Due in Next’ option with configuration as below shows the data
for the next Weeks as per set option.
The configuration for Anchor Date is saved when Dashboard is saved and can
be updated as per requirements.
Related Articles
Date and Time Formatting on Chart
In RubiSight, when you plot a chart using the Date and Time formatting feature, the coordinates of the plot appear in the standard ISO format, by default, as given below. Format: YYYY-MM-DD HH:MM:SS Where, YYYY-MM-DD is the date components of the ...Using Save As Option
After creating a data dictionary, you can make a copy of it with a different name using the Save As option. For creating a data dictionary, refer to Creating New Data Dictionary. To use Save As option, follow the steps given below. Open the data ...Validation using the Validate Option
The Validate option is available on the Function Pane of the workbook or workflow canvas. To validate a workbook or workflow using the Validate option, follow the steps given below. Open the workbook or workflow on which you want to work. Refer to ...Validation using the Validate Option
The Validate option is available on the Function Pane of the workbook or workflow canvas. To validate a workbook or workflow using the Validate option, follow the steps given below. Open the workbook or workflow on which you want to work. Refer to ...Search Option in Data Pane
When creating dashboards, we add datasets to them to plot various widgets. To plot widgets, multiple datasets can be used on the same dashboard page, or the same dataset can be used on multiple dashboard pages. All these datasets are parked in the ...