Issue
When using Custom SQL, an error similar to the following may occur:"TableauSQL.1" is not valid in the context where it is used. "
SELECT count(*) AS "a" FROM Table1
SELECT "TableauSQL"."a" AS "a" FROM ( select count(*) AS "a" from Table1 ) "TableauSQL"
SELECT count(*) FROM Table1