Database Reference
In-Depth Information
To D I S PL Ay
ForMuLA
r E Su LT
Same month last
year
(year-1).month
Current month for last year. For
example, if the current month
were December, 2010, then
(year-1).month
would show
information for December, 2009.
Same range of
a period of six
months last year
(year-1)
.(month-5):
(year-1).(month)
From 18 months ago to one year
ago. For example, if the current
month were December 2010,
then
(year-1).(month-5):
(year-1).month
would show
information for the time period
ranging from June, 2009 to
December, 2009.
Same range of
months to date for
last year
(year-1)
.firstmonth:
(year-1).month
From the first month of last year
up to and including the month
parallel to the current month this
year.
Year to date
yeartodate
A single time period representing
the aggregation of values from
the beginning of the year up to
and including the last completed
period. The period corresponds
to the most specific time period
defined for the data source.
Year to date
(by month)
yeartodate
.fullmonth
A single time period representing
the aggregation of values from
the beginning of the year up to
and including the last completed
month.
Year to date
(by day)
yeartodate
.fullday
A single time period representing
the aggregation of values from
the beginning of the year up to
and including the last completed
day.
Parallel year to
date
yeartodate-1
The aggregation of the same set
of default time periods completed
in the current year except for the
prior year.
Parallel year to
date (by month)
(yeartodate-1)
.fullMonth
The aggregation of time peri-
ods last year that is equal to year
to date periods for the current
year.
