Parsing of SQL query failed. Please check the SQL syntax.
I am trying to have Zoho Analytics recognize that if the a Deal is in Stage "Need Docs" it should also be counted as a Deal in the Stage "New Lead"
/*New Lead*/
SELECT
"ID"
'New Lead' AS "Stage"
From "Deals"
Where "Stage" = 'Need Docs'
Union All
Parsing of SQL query failed. Please check the SQL syntax.
Some tips:
Parse error at line 4, column 28. Encountered: AS