4 Replies Latest reply on Jun 19, 2016 9:20 AM by Ariel Zimerman

    How to combine different sources (Amazon Redshift & Google Sheets)

    Ariel Zimerman

      So Guys,

      I have to report monthly activity from different properties. Most of the data I have it on redshift, but from other properties I have to get if from google analytics.

      So in order to make it more efficient I use google sheet to concentrate everything from GA.

       

      For summarize I don't have any problems, however when I try to a get a monthly comparative I don't know how to do it:

      In the screenshot above is everything from redshift.

      What I did was using the same name on the fields (country, product and date) on google sheet and I created the relationship between two sources.

      So what I want is to add another 2 products that I have in google sheets.

       

      However it doesn't work.  I mean I don't know how to make it work.

       

      Message was edited by: Ariel Zimerman