-
1. Re: View data table with 45 columns
Joshua Milligan Jan 17, 2013 8:13 PM (in response to Mclaine keari)McLain,
I assume the issue you are running into is that after a certain point you can't add any more rows or columns without having the header values getting concatenated together in the first row or column? By default, you can have 6 levels of rows or columns. You can increase that to 16 (from the Analysis menu select "Table Layout" --> "Advanced". But that won't get you to 45.
You could have 45 columns of measure values in a viz, but I don't see that after looking at your data.
One possibility is that if the 45 columns of data are your raw data source you can get that from a dashboard by selecting "View Data" and then look at the underlying raw data.
Beyond that...
...I'm sure you have a reason for wanting 45 columns in a detail table, but you're asking Tableau to do something it isn't designed to do: give you a bunch of raw data as a visualization. Tableau is designed first and foremost to allow you to visualize data in ways that help you understand large amounts in an intuitive way. A table with 45 columns of text doesn't fit that paradigm.
Having said that, there may be a way to meet your requirement. But it may require you to do one or more of the following:
1. change your paradigm
2. refine your requirements
3. do something outside the box
If you can give some specifics of what you want to do and why you want to do it, it would probably open up a great discussion.
-
2. Re: View data table with 45 columns
Mclaine keari Jan 17, 2013 7:58 PM (in response to Joshua Milligan)Joshua,
Your reply much appreciated.
I reviewed the requirement and reduced the number of columns to 15 and was able to create a text table that fitted all fields perfectly! The Action Filter and the text table are now working like skate on ice.
Thanks alot for providing great advice to help.
Cheers
-
3. Re: View data table with 45 columns
Alex Kerin Jan 18, 2013 5:05 AM (in response to Mclaine keari)There's an idea here for a horizontal scroll bar: http://community.tableau.com/ideas/1136 I often have tables which would benefit from it