Calculations Flashcards
1
Q
There are three types of LOD expressions you can create in Tableau:
A
- FIXED
- INCLUDE
- EXCLUDE
2
Q
- level of detail expressions compute values using the specified dimensions without reference to the view level of detail—that is, without reference to any other dimensions in the view
- level of detail expressions also ignore all the filters in the view other than context filters, data source filters, and extract filters.
A
FIXED
3
Q
- level of detail expressions compute values using the specified dimensions in addition to whatever dimensions are in the view.
- can be useful when you want to calculate at a fine level of detail in the database and then re-aggregate and show at a coarser level of detail in your view
- level of detail expressions are most useful when including a dimension that isn’t in the view.
A
INCLUDE
4
Q
- level of detail expressions explicitly remove dimensions from the expression—that is, they subtract dimensions from the view level of detail
- level of detail expressions are most useful for eliminating a dimension in the view
- level of detail expression cannot be used in row-level expressions (where there are no dimensions to omit), but can be used to modify either a view level calculation or anything in between (that is, you can use an EXCLUDE calculation to remove dimension from some other level of detail expression)
A
EXCLUDE
