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 Revenue FOR Next(Quarter)
By default, FOR Next()refers to values from one time period in the future. This can be customized 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 Payment FOR Next(Quarter,3)
Thank you for your feedback!
Thank you for your feedback!
If you can't find what you need, don't hesitate to send us a comment.
Any questions?
Check out the GoodData community.