8 Replies Latest reply on Nov 18, 2016 2:07 AM by Fabio Guimaraes

    Connecting date time field within three different sources

    Fabio Guimaraes

      Hi guys!

       

      I have three sources in my Tableau:
      1 - Google Analytics Connection
      2 - Excel File (Radio)
      3 - Excel File (TV)

       

      I need to connect the exactly date and the exactly hour of those sources.

      In all three files, I have the dimensions DATE (Date Format) and Hour (# Two digits hour of the day).

      I want to connect the DATE and HOUR of my sources and compare some measures.
      My problems:
      - The main source should be the Google Analytics because the other sources doesn't have all dates
      - If I create a calculated field for Date and Hour and them connect the sources, I can't have a timeline as the picture bellow

      - If I create a calculated field for Date and Hour and them connect the sources, I can't filter and play with some dimensions of my sources 2 and 3

       

      Appreciate any help here.

       

      Tks

      Snap 2016-11-17 at 17.16.34.png