Why is my table calc not calculating properly in merged results?

[LookerExperts]

Knowledge Drop

Last tested: Jun 18, 2018

This may be due to ambiguous column names. IF several columns having the same name in merged results, the table calc does not know how to pick which one, and chooses the first one by default.

NOTE: The ambiguity problem persists if there is a table calc used in either of the source queries.

This content is subject to limited support.