2 Replies Latest reply on Feb 3, 2016 11:11 PM by Eng Soon Wong

    DATEADD('hour', [Diff from UTC], [DateTime Created at]) returns errors?

    Eng Soon Wong
    Eng Soon Wong Jan 28, 2016 1:31 AM

      Dear Tableau Community,

       

      Used the above calculated field to convert UTC time to US states local time with a referencing table that looks something as below.

        

      ZipDiff from UTC
      00544-5

      Master table contains Zip code, DateTime Created at in UTC format. Every row contains a time stamp in DateTime Created at UTC format.

       

      Secondary table contains Zip code and Difference from UTC- that expresses UTC time to US states local time according to zip code.

      Every row contains a zip code and its corresponding difference from UTC time.

       

      When I blend both data together with above DateAdd calculated field, I get the error

      "All fields must be aggregate or constant when using table calculation functions or fields from multiple data source".

       

      I think this should be a row calculation and not an aggregate calculation. Am I correct? How should I correct my formula to remove the errors?

       

      Appreciate all advice please!

       

      Thanks!

      Wong ES