Date-based View Filter
Check out the walk-through on how to filter a View based on Date values.
![](https://docs.bdb.ai/~gitbook/image?url=https%3A%2F%2F972575688-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FRYq1HgffNfbnIMWPu1D5%252Fuploads%252FNhVtEPOagQPUiOCKqKl4%252FFilterWithDateColumn.gif%3Falt%3Dmedia%26token%3D851518c5-de77-42a0-af5e-18e404ffb0fb&width=768&dpr=4&quality=100&sign=cc96dd5c&sv=1)
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, and 2. Relative
Between
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.
![](https://docs.bdb.ai/~gitbook/image?url=https%3A%2F%2F972575688-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FRYq1HgffNfbnIMWPu1D5%252Fuploads%252FmxeEPx7PlH6XfJjqBbOw%252Fimage.png%3Falt%3Dmedia%26token%3D39a6c320-dd56-4787-b6d6-0306c30882c3&width=768&dpr=4&quality=100&sign=3db81df9&sv=1)
The View Filter icon gets highlighted.
The selected view gets filtered as per the applied filter conditions.
![](https://docs.bdb.ai/~gitbook/image?url=https%3A%2F%2F972575688-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FRYq1HgffNfbnIMWPu1D5%252Fuploads%252FTSXwTYdeYz4UuHtLPLgZ%252Fimage.png%3Falt%3Dmedia%26token%3Df94f5db5-df0a-465e-98e2-044667d8287e&width=768&dpr=4&quality=100&sign=b5d823f4&sv=1)
Relative
Click the Filter icon on the Design page.
The Filter panel opens.
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.
![](https://docs.bdb.ai/~gitbook/image?url=https%3A%2F%2F972575688-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FRYq1HgffNfbnIMWPu1D5%252Fuploads%252FmxoUszASkvfcLtYqN5uG%252Fimage.png%3Falt%3Dmedia%26token%3Dcc9c7d42-4a72-4aec-bc0b-b0de268e71c9&width=768&dpr=4&quality=100&sign=eae5dff3&sv=1)
The View Filter icon gets highlighted.
The selected view gets filtered based on the applied conditions.
![](https://docs.bdb.ai/~gitbook/image?url=https%3A%2F%2F972575688-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FRYq1HgffNfbnIMWPu1D5%252Fuploads%252Fcw8AUvAUSGG7ymMiSnDC%252Fimage.png%3Falt%3Dmedia%26token%3D7f54c991-1513-4d6e-83d3-72fab3db4c96&width=768&dpr=4&quality=100&sign=817eb121&sv=1)
Please Note: The same set of steps can be used to apply the Global filter based on the date values.
Last updated