I have this error if I try to create a report like this:
My Module version:
for the icingadb reports the syntax/fields are a little different.
I recommend to build the query in the webgui and then copy and past it. maybe revert the url encoding:
try out this: