Hello @Joseph_Riley,
Welcome to the community.
Problem
This happens with many users, for example, when they are in the module setting mapping dialogue and use some of the keywords specific to module settings but simultaneously conflict with Make’s predefined keywords.
Explanation
In your implementation, you need to use max() of Google Sheet Chart Query but in the mapping dialogue when you type max() it automatically converts it to Make’s default function.
Solution
In that type of situation, you can usually just go to any basic text editor, like Notepad or Sublime, and simply write your function, copy it from there, and paste it here.
For now, you can use this one and paste it. But just remember it for the future.
select max(column)
P.S.: Always search first, Check Make Academy. If this is helpful, Mark Best Answers as Solutions 
and give 
If you need expert help or have questions? Contact or comment below! 