This documentation is for an older version of GoodData.
Go to the latest version of this article.
FOR Next
By default, the FOR Next function refers to values from one time period in the future. This can be customized by adding a second parameter to the function.
Syntax
SELECT … FOR Next(…,…)
SELECT metric FOR Next(time_attribute)
Examples
SELECT {metric/revenue} FOR Next({attribute/quarter})
You can customize FOR Next() by adding a second parameter to the function. For example, you might want to return a payment value from three quarters in the future with respect to a certain time period (see below).
SELECT {metric/payment} FOR Next({attribute/quarter},3)