Is anyone able to help with this question, I still haven't resolved it.
The attached image shows the problem. Clocktime appears to be exactly the same between c:Imports and m:ftmCharge but Tableau doesn't think the points occur at the sametime (except every 9 periods when it does) and so it ends up duplicating for example 11:05 twice on the x axis in my charts.
Any help would be most appreciated!
rows-dont-align.png 90.8 KB
You are doing an addition in Excel to derive the Clocktime from the UTCtime in the Landlord tab, and that must be causing the rounding issue.
That's why the Clocktime in your landlord tab does not tie out with the other two tabs where there is no addition.
You can create a calculated field as shown below which ensures that the times are in sync.
You should not have a problem with the data then as can be seen below.