So far, we have covered the first of our two major questions: What is the function? Now we will proceed to the next question: How is the function applied?
Let's try to understand that question via the following three options:
|
One Application of INDEX() |
Another application |
... and another |
 |
 |
 |
The INDEX function is used in each of these three screenshots; however, it is applied differently in each. The first and second screenshots both display 1,2, and 3, but differ directionally. The third screenshot ranges from 1 to 9. How is Index being applied in each case? Answering this question can be confusing because Tableau uses different terminology. Within Tableau itself, the way a table calculation is applied may be referred to as running along, moving along, compute using, or partitioning and addressing. For our purposes, we will...
