2 Replies Latest reply on Oct 21, 2018 6:20 AM by Josh Ciszek

    Too many records on join

    Josh Ciszek

      My issues is not the logic of the view, but the excessive time to query based on the size of the resulting data set...

       

      I'm joining 3 tables that results in millions of records in Tableau.  The Outcomes table is essentially a survey with 150 questions administered multiple times to a client.  Second is a table that holds all the services provided to a client...which can be numerous per client.  Table 3 as client enrollment into different programs.  As you can imagine, any kind of join on ClientID results in a huge data set.

       

      However, I need to analyze relationships that span all tables.  For example...for clients with multiple surveys (i.e. matched pairs), show how many services were provided within 30 days of the first enrollment date (min(EnrollDate)).

       

      Thoughts?