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)

FOR PreviousPeriod