Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

 

The Offset date option allows you to set a date (or date range) based on today's date, so that the data continues to update. Instead of a fixed date such as 'Start: January 2014' or 'End: March 2014' you can define a dynamic range such as 'year to date' or 'Last month'.

Table of Contents
maxLevel3
minLevel2

When offset dates are available

Offset dates are available when adding a period to the defined period list and when setting period option as part of defining a measure (for custom mode or advanced search). You will be presented with a slightly different window depending what you are doing, but the concept is the same.

 

 


How to apply offset dates

  • For all period types other than 'day', enter the offset date as a number. The timeframe will be displayed in words next to the offset field, e.g., if you select 'Month' as your time unit, an offset of 0 means the current month, an offset of -2 would be two months ago (as shown in the image below), and so on. You can choose to set both the start and end dates as offsets, or just one. Save & Apply.

    See below for information about setting day-based date ranges.


    Image Modified

Offset options for day-based date ranges

When you are defining a date range using 'Day', you can choose from Actual, Offset and Special options. 

  • Actual - choose the required date.

  • Offset - enter or select a number of days.


    (tick) Tip. A quick way of getting the correct offset value is to set an actual value and then switch to offset. It will set the offset value to match the previously selected date.

  • Special  - choose one of four 'matches' ('First Day', 'Last Day', 'Match Today' or 'Match Yesterday') and offset that match against a chosen month. 

    Image Modified

    About each match

    • First Day: First day of the offset month.

    • Last Day: Last day of the offset month.

    • Match Today: Tries to match today's date in the offset month.

      • If today is the 13th, you will get the 13th of the offset month.

      • If today is the 29th, 30th or 31st and a direct match is unavailable, you will get the closest match.

    • Match Yesterday: Tries to match yesterday's date in the offset month.

      • If yesterday is the 12th, you will get the 12th of the offset month.

      • If today is the 1st, you will get the last day of the month prior to the offset month.

      • If yesterday is the 29th or 30th and a direct match is unavailable, you will get the closest match.

When do I choose a special date over an offset date?

  • To analyse a If you need to An example of when you might want to Offset:  Choose a Choose a day that is based on a day offset - either forwards or backwards from today.   For example, choose offset for a analysing a rolling 7 day period.
  • Special:  Choose Choose a day that is based on a month offset.  Users Users can choose from a certain type of day in a particular month.   For example, choose special for analysing month-to-date.

Examples of date settings

Table of Content Zone
maxLevel4
minLevel4

Common default settings

Note:  These settings are designed to work into the future, without needing to adjust them every month or every year. 

Example

Time unit

CurrentPrevious

Start

End

StartEnd

Calendar Year to Date

Month

Not Offset. Choose January and 'most recent'

Offset: 0

Not Offset. Choose January and 'second most recent'Offset: -12

Financial Year to Date

Month

Not Offset. Choose start month of financial year, e.g. July and 'most recent'

Offset: 0

Not Offset. Choose start month of financial year, e.g. July and 'second most recent'Offset: -12
Month to DateDaySpecial. Choose first day of month 0.Offset: 0Special. Choose first day of month -1.Special. Choose match today of month -1

Offset date settings 

Example

Time unit

Start

End

Last month

Month

Offset: -1

Offset: -1

This month

Month

Offset: 0

Offset: 0

Rolling 12 months

Month

Offset: -11

Offset: 0

Today

Day

Offset: 0

Offset: 0

Yesterday

Day

Offset: -1

Offset: -1

Last 7 days

Day

Offset: -6

Offset: 0

Last three years

Year

Offset: -2

Offset: 0

'Special' date settings

Option

Offset

What is displayed

First Day

-3

First day of 3 months ago

Last Day

1

Last day of next month

Match Today

4, -1, -3

Today 4 months ahead, Today last month, Today 3 months ago

Match Yesterday

5, 1, -2

Yesterday 5 months ahead, Yesterday next month, Yesterday 2 months ago

Match Today

0

Today

Match Yesterday

0

Yesterday