1 Reply Latest reply on Mar 31, 2016 2:46 AM by Thomas Laughton Smith

    Lost data in full join after filtering issue

    Thomas Laughton Smith

      I have two reports from one data source that I have connected with a full join so as to keep all the data.

       

      One is a purchase report, showing all purchases.

      The other is our total list of customers ever.

      They are linked via customer ID.

       

      I applied a filter on 'purchase date' so that it only shows the last year. I was hoping it would filter the purchase report and leave the customer list intact (given that there is no purchase report field in that report)

       

      Unfortunately what has happened is that tableau has filtered the customer list as well, so this has been shortened. How to apply a filter to just one of the reports but not the other? The data set is too large to extract without filter and then filter inside tableau....

       

      Possible?

       

      Thanks