Skip to main content

Predefined Ranges

  • 2 minutes to read

The Range Filter dashboard item allows you to add a number of predefined date-time periods that can be used to perform a selection (for instance, year-to-date or quarter-to-date).

Add Predefined Ranges

To add a predefined range, open the Range Filter’s Options menu, go to the Custom Periods section, and click “+”.

wdd-range-filter-custom-intervals

Boundaries Settings

You can specify the following settings for the start/end boundaries.

Caption
Specifies a custom periods caption.
Start Mode
Specifies a mode of the start boundary.
End Mode
Specifies a mode of the end boundary.

Boundaries Modes

The following modes are available for the start and end boundaries:

None
The selection begins from the start/end of the visible range.
Fixed
Allows you to select a specific date value using the calendar. Use the Start/End Date option to set a value.
Flow
Allows you to select a relative date value. The Interval option specifies the interval between the current date and the required date. The Offset option allows you to set the number of such intervals. The Offset option can accept negative and positive values. Negative values correspond to dates before the current date, while positive values correspond to future dates.

Below you can find several examples of how to set up custom periods.

Fixed Custom Periods Examples

Name

Settings

2018

Start Point

  • Mode: Fixed
  • Start Date: 01/01/2018

End Point

  • Mode: Fixed
  • End Date: 12/31/2018

Q1 2017

Start Point

  • Mode: Fixed
  • Start Date: 01/01/2017

End Point

  • Mode: Fixed
  • End Date: 03/31/2018

Flow Custom Periods Examples

Name

Settings

6 Months

Start Point

  • Mode: Flow
  • Interval: Month
  • Offset: -5

End Point

  • Mode: None

Year to date

Start Point

  • Mode: Flow
  • Interval: Year
  • Offset: 0

End Point

  • Mode: Flow
  • Interval: Day
  • Offset: 0

Last Month

Start Point

  • Mode: Flow
  • Interval: Month
  • Offset: -1

End Point

  • Mode: Flow
  • Interval: Month
  • Offset: 0

Select Predefined Ranges

Click the Select Date Time Period button (the wdd-range-filter-custom-period-icon icon) in the Range Filter’s caption and select the required period from the list:

wdd-range-filter-select-custom-period