User Guide
×
Menu
Index

TabReference - by Position

 
In addition to using the name of your question specifically in the expression, you can also retrieve data from a particular position in the table. This is useful when your Connection is set up to dynamically retrieve data from the two most recent periods, instead of specific periods such as 2020 and 2021.
 
 
1. Set up the following rules in Connect.
 
2. Then in the expression, instead of typing in the specific year, you can enter 1. If we change connection because for example new wave of data appears, or we switch to a different country that has a different set of periods available, we will still show the first available Dataset Year from the query.