> For the complete documentation index, see [llms.txt](https://help.tellius.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.tellius.com/tellius-6.4/vizpads-explore/date-picker-in-filters.md).

# Date picker in filters

Explore the new features of Tellius, including an intuitive date picker and time slicer, enhancing your data analysis experience effortlessly.

### **Why time slices?**

With our custom time slice picker, you can visualize data for different time slices (e.g., calculate percentage change or absolute change). These time slices can either be 3 weeks over 3 weeks change or last 3 weeks compared to the same 3 weeks last year. Support for such custom time ranges allows users to define their own **Time Period** and compare the data for different time frames as required. Also, scroll down to know how to customize the calendar view.

### **Where to find the time slices?**

Time slices can be created for any date range filter in Vizpads and Insights (the **Vizpad** and **Insight** modules; the **Explore** and **Discover** tabs in releases before Tellius 6.4).

### **Time period filter in Tellius 6.4**

When you add a filter on a date column in a Vizpad (in the **Filters** panel, pick the **Business View** and the date **Column**, then click **Date** to select the time period), the **Time period filter** dialog opens.

<figure><img src="https://1702728550-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FC5PhRxmOjkQZJEO6F9Zw%2Fuploads%2FYMiCqGbhvpVKqpVF4KlI%2Ftime-period-filter-relative-64.png?alt=media&amp;token=4c1347df-0d94-408f-949d-c121426d4535" alt="Time period filter dialog with the Days grain, the Relative options Yesterday, Today, Tomorrow, Last N days and Next N days, a two-month calendar, and Available dates, Last Refresh and Today&#x27;s Date below it" width="563"><figcaption></figcaption></figure>

1. Pick the time grain at the top: **Days**, **Weeks**, **Months**, **Quarters** or **Years**.
2. Choose how to set the period:
   * **Relative:** periods counted from the latest date in your data. For days, the options are **Yesterday**, **Today** (the date your data ends on), **Tomorrow**, **Last N days** and **Next N days** (a rolling window backwards or forwards from the latest date in your data; set the number of days). The other grains offer the same pattern, for example **Previous week**, **This week**, **Next week**, **Last N weeks** and **Next N weeks**.
   * **To Date** (Weeks, Months, Quarters and Years): **Week to date** and **Last week to date**, **Month to date** and **Last month to date**, **Quarter to date** and **Last quarter to date**, **This year YTD** and **Last year YTD**.
   * **Custom Range:** set the **From** and **to** dates, or click a **Quick** option: **Last 7 Days**, **Last 30 Days**, **Last 90 days**, **YTD** or **Last Year**.
3. Check the line below the options (for example, "Showing data for today"), which says in words which period the filter will show.
4. Click **Apply** to apply the filter, or **Cancel** to close the dialog without changing it.

<figure><img src="https://1702728550-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FC5PhRxmOjkQZJEO6F9Zw%2Fuploads%2FN1Mwitia5GPVFskaln6S%2Ftime-period-filter-custom-64.png?alt=media&amp;token=a32897ab-5308-416a-9d54-20502b21e350" alt="Time period filter dialog on Custom Range, with From and to date fields, the Quick options Last 7 Days, Last 30 Days, Last 90 days, YTD and Last Year, and the selected range on the calendar" width="563"><figcaption></figcaption></figure>

On Tellius 6.4, the dialog also shows a two-month calendar with the selected range highlighted, and below it:

* **Available dates:** the date range in the selected Business View.
* **Last Refresh:** the date the Business View's data was last refreshed.
* **Today's Date:** the current date.

{% hint style="info" %}
Use **Relative** or **To Date** periods for Vizpads that people open every day or week: the filter moves with your data, so "Last 30 days" always means the latest 30 days. Use **Custom Range** for a fixed period, such as a closed quarter you report on.
{% endhint %}

### **Date picker in releases before Tellius 6.4**

In **Release 4.0**, the date picker was redesigned. In releases before Tellius 6.4, when you filter using a date-based column, a date picker window appears.

1. The left pane **Pick Time Period** displays a list of pre-defined date ranges. Select the required date range.
2. The **Time Period** displays the exact ‘From’ and ‘To’ dates in MM/DD/YYYY format.
3. The corresponding range will be highlighted accordingly and displayed on the calendar.

{% hint style="info" %}
If you select any of the preset date ranges from **Pick Time Period**, you won’t be able to manually interact with the calendar or apply changes to the **Time Period** fields.
{% endhint %}

4. If you select **Custom Date Range** in the left pane, you can manually change the **Time Period** fields. Alternatively, you can interact with the calendar to select the required dates, and the **Time Period** fields will be updated accordingly.
5. **Custom Time Slicer** allows you to create a custom time period instead of date ranges.
6. Select **Custom Time Slicer** in the left pane; you can find another row of fields added under **Time Period**.
7. Click on each field to view the corresponding dropdown list, where you can select the required time slice. The dates on the calendar will be highlighted accordingly.
8. Using **Custom Time Slicer**, you can select *previous/next ‘n’ number of days/weeks/months/quarters/years* that exist in *this/last/last to last year*.
9. Below the calendar, you can find the following details:

* **Available dates:** The available date range according to the selected Business View.
* **Last refresh:** The date on which the dataset from the Business View was last refreshed.
* **Current date:** The current system date.

<figure><img src="https://content.gitbook.com/content/C5PhRxmOjkQZJEO6F9Zw/blobs/s3i8dAHj1nKF08VEpBiA/date-picker.gif" alt="" width="563"><figcaption><p>Date picker window in action</p></figcaption></figure>


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://help.tellius.com/tellius-6.4/vizpads-explore/date-picker-in-filters.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.