Date Range

A way for the user to choose a specific time period for which the data will be shown

When the filter is tied with those elements, the user will be able to filter dates specific dates, date ranges, or even preset dates. It's a super important axis for storytelling.

Configuring Period Types

You can select all the period types relevant to your appโ€™s storytelling needs.

By default, you will see only days. You can also enable and disable:

  • Days

  • Weeks

  • Months

  • Quarters

  • Years

Each of these period types comes with formatting options.

Note that the format and language depends on your app language - for now, only English, French and Spanish are available.

Configuring Date Limits

Date limits represent the bounds of the selectable dates. Configuring โ€œdate limitsโ€ will limit the visibility of the calendar for an End User selecting dates and date ranges.

Letโ€™s say you have 5 years of history and you want to limit your user selection to the last 3 years. You can set the date limits so users will only be able to select dates within the last 3 years.

You can configure date limits through different methods:

  • Using preset date ranges (that we have prepared for you). You will see them appearing on the left of the โ€œDate Limitโ€ configuration panel:

  • Using relative dates: define an interval from/until a reference date. Do this by selecting a number, a period type, from/until, and a reference date (today, yesterdayโ€ฆ)

Note that the from/until operators are inclusive, e.g. until โ€œTodayโ€ will include today.

  • Using fixed dates on a calendar:

Note that currently, you can only have multiple selections in the โ€œDaysโ€ tab.

Configuring Custom Periods

โ€œCustom periodsโ€ are a nice way for you to add pre-selected date ranges that are relevant to your business.

Letโ€™s say you are working in retail: you can create a date range called โ€œBlack Friday 21โ€, that users will be able to select easily.

  • To do so, you can click on โ€œAdd custom rangeโ€:

  • Give a name to your custom range and configure it by using โ€œPreset Datesโ€, โ€œRelative Datesโ€ or โ€œFixed Datesโ€ (this is the same user experience as in โ€œDate Limitsโ€, see above).

You can also delete (clicking on the bin icon) or modify (clicking on the โ€œ+โ€ icon) already set custom periods.

Configuring a Default Value

The default value is the default selection appearing when users login to the app for the first time. The default value is also displayed when users empty the selection they made.

As an App Builder, you will be able to select between custom periods (see above), or preset values that we have picked for you.

You can check the video in the โ€œCustom Periodsโ€ paragraph to see how to configure this.

Templating

More information on templating capabilities in this page.

Information

In the "Information" section, you can retrieve filter properties, such as the id, useful for Templating (cf. Templating from Filters' values)

OptionDescription

id

Unique identifier of the Filter

dataset

Source dataset

column

Column from which filter's values comes from. (The column's type must be date)

Last updated