You are viewing our older product's guide. Click here for the documentation of GoodData Cloud, our latest and most advanced product.

FOR Previous

By default, the FOR Previous function refers to values from one time period ago. You can customize FOR Previous by adding a second parameter to the function.

For differences between FOR Previous and FOR PreviousPeriod, see Functions For Referring to Past Time Periods.

Syntax

SELECT … FOR Previous(…,…)
SELECT metric FOR Previous(time_attribute)
SELECT metric FOR Previous(time_attribute, #periods_ago)

Examples

SELECT Revenues FOR Previous(Quarter)

By default, FOR Previous()refers to values from one time period ago. This can be customized by adding a second parameter to the function. For example, you may want to return a revenue value from three quarters ago (see below).

SELECT Revenues FOR Previous(Quarter , 3)

To be able to use FOR Previous to compare data to the same period of the last quarter/year when filtering by weeks, do the following:

Switch the version of the Extensible Analytics Engine (see XAE - Extensible Analytics Engine) to 3. To do so, set the xae_version platform setting to 3 (see Configure Various Features via Platform Settings).
Migrate the Date datasets in your project to the urn:custom_v2:date date dimension. To do so, see “Migrate from a Legacy Date Dimension to urn:custom_v2:date” in Manage Custom Date Dimensions.

FOR PreviousPeriod