What is the function?
As discussed in the introduction to this chapter, it may be helpful to enhance your understanding of table calculations via the following two questions: What is the function? and How is the function applied?
We will begin by considering how each table calculation function can be considered directional or non-directional.
Directional and non-directional
As of Tableau 10, there are 32 table calculation functions in Tableau. However, many of these are simply variations of a theme; for example, there are five Running functions, including RUNNING_SUM and RUNNING_AVG. If we narrow our consideration to unique groups of table calculations functions, we will discover that there are only 11. The following table shows these 11 functions organized in two categories:
|
Directional table calculation functions |
Non-directional table calculation functions |
|
|
|
|
|
|
|
|
|
|
| |
|
| |
|
| ... |
