That works great for excel but this is coming from MS SQL and Tableau does not allow a centroid from SQL
1 of 1 people found this helpful
Then why not union the data in query level such as below rather than do it from tableau side?
select [Office],[TIGEROutputAddress] as Address, [Latitude],[Longitude], Null as Gender from [Offices Table]
select Null as Office, [TIGEROutputAddress] as Address,[Latitude],[Longitude],[Gender] from [People]
Yes. This is my initial thought but was hoping for something that would make labeling the offices and addresses differently a little more elegant.