Did you come across a time when Tableau would not allow you to drag a calculation to the dimension field? It may be frustrating when you want to apply them as the dimensions when you would like to create a group or a set to them. In this blog, I am going to explore 3 kinds of numeric calculations that can’t be the dimensions in Tableau.
3 calculations can’t be the dimensions in Tableau
- Exclude and Include LOD calculation:
- Table calculation:
- Basic aggregation calculation:
The way to fix this problem
Generally speaking, Tableau won’t allow you to use a calculation that will change base on the view. Next time when you come across that, use a Fixed calculation to fix it or try to avoid the aggregation.