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
Drill Through from Chart to Page with Context Filtering
Drill Through Filters (Page Level) Overview Drill Through Filter option is available at the page level in the Filter Pane and is accessible from Edit/View/Outer modes. It enables navigation from one widget to another page while passing contextual ...Drill Through with Keep All Filters
Drill Through with Keep All Filters This option is available from Rubisight dashboard edit mode. This option is available in page format settings. This is used to carry forward all applicable filters on the respective chart which is drilled through. ...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 ...Button Chart for Dashboard or URL Navigation and Filtering
1. Overview • The Button Chart widget allows users to create interactive buttons inside dashboards. • It supports navigation to dashboards, pages, filters, or external URLs. • Navigation works only in View / Publish / Outer modes (not in Edit ...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 ...