Date-based View Filter

Check out the walk-through on how to filter a View based on Date values.

Applying Date-based View Filter (Between)

Applying Date-based View Filter (Relative)

The users can apply Date based View Filter by selecting the Date Values from the Data Store. The user can provide two kinds of conditions on the Date values:

1. Between

2. Relative

Between

• Avail a View on the Design canvas containing the Time dimension.

• Click the Filter icon on the Design page.

• The Filter panel opens, displaying all the available filter values.

• Select a dimension or measure containing Date values to filter the View.

• Choose the Between option from the drop-down menu.

• Provide the From and To dates.

• Click the Apply icon.

• The selected view gets filtered as per the applied date filter conditions.

Relative

• Create a View with the Date Dimension.

• Click the Filter icon on the Design page.

• The Filter panel opens.

Selecting a Time Dimension from the Filter Panel

• Select a Date value as the filter condition.

• Choose the Relative option from the drop-down.

• Insert a period by selecting the required values.

  • The user gets the Last and This under the drop-down menu to select the past or present time zone.

  • There are 4 categories of time pointers provided in another drop-down menu, which allow the user to select a value out of Years/ Months/Weeks/Days. E.g., the below-given image displays the Last 5 years as the selected time condition.

• Click the Apply icon.

• The selected View gets filtered based on the applied date conditions.

View Filter based on the Time Dimension with Relative option

Please Note: The same set of steps can be used to apply the Global filter based on the date values.​