6 Replies Latest reply on Aug 6, 2013 3:06 PM by Meg Narasimhan

    Why do I have to keep creating the relationship when I update my Google Analytics extract?

    Sabrina Jordan

      I have Google Analytics set as a data source with the past 30 days as the time frame.  When I blend it with my SQL database, I have to set an hour-to-hour connection and a MDY-to-MDY connection because GA stores the hour in a different field and my SQL database is a full timestamp.  However, each time I refresh my GA extract (SQL is live), Tableau loses the relationships I set and I have to set them again manually each time.  Do I have a setting wrong somewhere?  Why won't it save the link I already made when the fields aren't changing?

       

      Thank you very much for any help you can offer!