3 Replies Latest reply on Jan 18, 2013 5:05 AM by Alex Kerin

    View data table with 45 columns

    Mclaine keari

      Hi all,


      I am starting in Tableau Desktop and would like to know how i can create a view data table with detail records of about 45 columns. I have created an Action Filter and would like to link the view to the detail table with all the columns(45).


      Please see attach is the spreadsheet that i would like to replicate as view data table in Desktop.





        • 1. Re: View data table with 45 columns
          Joshua Milligan



          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



            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.



            • 3. Re: View data table with 45 columns
              Alex Kerin

              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