3 Replies Latest reply on Mar 3, 2017 7:06 AM by John Smith

    Bar Charts Not Showing All of Our Sales Data

    John Smith

      Edited: Added screenshot, the filters that are selected seem to be accurate as far as our data goes, any suggestions on next steps? Thank you for your time.

       

      Please forgive vagueness, missing step-by-step instructions/screenshots to recreate issue, working with limited access, late at night, trying to get the ball rolling on this before waking up at sunrise to take action. New to Tableau may need to repost but any general suggestions very much appreciated.

       

      When my coworker logged in earlier, his home page showed bar charts, showing monthly  sales...January, February, etc. For some reason or another the bar charts did not show all of our sales data, maybe only 75% of our sales showed up on the bar charts. Is there any general suggestions as to how I can figure out if the issue is that the data we imported from Excel is somehow in the incorrect format, versus checking if this is a user training issue, or possibly a settings issue with Tableau? Thank you.

       

      Edited: Added screenshot, the filters that are selected seem to be accurate as far as our data goes, any suggestions on next steps? Thank you for your time.

       

      Screenshot.png

        • 1. Re: Bar Charts Not Showing All of Our Sales Data
          Christina Gremore

          The most likely explanation is that there is some kind of filter working. When you look at the sheet, are there any fields on the filter shelf? Are there any data source filters being applied?

           

          How do you know that data is missing? What granularity is your data stored at (e.g. is there one row for every Order ID, every item...?) View the underlying data and compare it to your original data source (the one that's telling you the Tableau number is wrong) to find out which rows are missing. Check to see whether the "missing rows" are really missing (i.e., not being pulled into Tableau) or whether they are just appearing somewhere you don't expect (sometimes end-of month transactions can be attributed to the following month instead of the current month, due to timestamp discrepancies).

           

          If this helped resolve your issue, please mark your question as answered.

          • 2. Re: Bar Charts Not Showing All of Our Sales Data
            Matthias Goossens

            Yo John!

             

            It's alway difficult to validate data by looking at a bar chart.

            The best way to check your data is by creating a simple table in Tableau that shows you all the dates and the amount of sales.

             

            In case you don't get the right result, try checking these things:

             

            - Did you join the sheets from your excel file? If that's the case, double check all your joins

            - Are you using a live connection to your excel file or are you working with an extract? In case you are working with an extract. Make sure that no new data was added to the excel after you created the extract
            - Maybe you added some data source filters?

            - It could be you added a filter to your view?

             

            It's always easier for us to help you if you could post some images or a twbx.

             

            I hope it gets sorted out!

             

            Cheers,

            Matthias

            • 3. Re: Bar Charts Not Showing All of Our Sales Data
              John Smith

              Floating my mouse over the bar graphs gives data that is incorrect as far as "business won", either too high or too low but way off Any suggestions?

               

               

               

              Screenshot.png