When I aggregate over more data, I get the below error message. I've tried multiple ways of diagnosis like going back to a version I know it was working fine (but still got the same error below). Please advise as this is a critical report where the business I support highly depend on on a monthly basis. Thank!

Error shown below:

This visualization cannot be shown. Please refresh the visualization or update its configuration.

Error in SQL statement: ParseException:

[PARSE_SYNTAX_ERROR] Syntax error at or near end of input(line 102, pos 85)