When drilling down into a hierarchy in Tableau it's showing the drill down in one column all concatenated. I would like these to show cleaner in multiple columns. How do I go about doing that?
Oct 23, 2017 9:09 AM
Looks like you are having Multiple Columns go to analysis>table layout>and Change Number of Columns to 16
As Deepak said, Analysis (from top menu) > Table Layout > Advanced > Columns: Increase to 10.
Tableau is concatenating your fields because it sees that you have too many columns in the view.
Hmmm... I tried that and refreshed the view and it's still only showing the one concatenated column when drilling down. Also, the other thing that I noticed it that because it's working this this way it's not giving me the minus '(-)' for drill-down capabilities.
You need to increase it for the Rows rather. Go ahead and make all of them 16.
Thanks guys! Setting the max rows and columns to 16 fixed it!