1 Reply Latest reply on Feb 27, 2014 10:39 AM by Shawn Wallwork

    Hi, The problem is that Tableau Public 8.1 not loading all elements from Excel sheet

    Cleveland Sasser

      Hi,

      TabPub 8.1 not loading all rows from Excel sheet.The data view counts 69 rows, which is correct, from Excel sheet. How to get TabPub to take all 69 rows data?

      Thanks!

      Cleveland

      Cleveland.sasser@piedmont.org

      Not Quite New-beTableau_DeviceFail_Prob1.png

        • 1. Re: Hi, The problem is that Tableau Public 8.1 not loading all elements from Excel sheet
          Shawn Wallwork

          Tableau aggregates things, that's a lot of what it does. If you put Number of Records on the Label shelf you'll see which device IDs have more than 1 record being aggregated. That's where your "missing" records are going. If you look down in the lower left corner you'll see you have xx number of rows (something less than 69) and you will also see you that the SUM(Number of Records)=69.

           

          What you'll need to do is use another field between the Location and the Device ID, a field that will prevent the Device ID from being aggregated, maybe an Order ID field (?) It just needs to be a field that isn't the same value for each of the Device IDs. If you don't have anything like this, go back to your Excel spreadsheet and create a new column that has a unique value for every record. Then bring the data back in and put this field between the Location and Device ID. Then you can hide this field by unchecking Show Header.

           

          --Shawn