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 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.

Zip	Diff 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

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

Fabrizio Puletti Jan 28, 2016 3:03 AM (in response to Eng Soon Wong)

Hi Eng Soon Wong,

I am not sure what the problem is here.

Since the ZIP code is common to both tables can you inner join the Master and Secondary table on Zip code during the import of the data?
This would create a unique table and you can easily use your calculation in that case.

For reference: http://onlinehelp.tableau.com/current/pro/online/windows/en-us/joins_addtables_multiple.html

Fabrizio
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
2. Re: DATEADD('hour', [Diff from UTC], [DateTime Created at]) returns errors?

Eng Soon Wong Feb 3, 2016 11:11 PM (in response to Fabrizio Puletti)

Many thanks!
Like Show 0 Likes(0)

Actions