When using Aggregation Average in a report, a user/admin may run into the error:
Syntax Error or Access Rule Violation detected by database (Unknown column 'avg_of_xxxxxxxxxx' in 'order clause')
This error may be caused because the "Aggregated Field" on the report may not be an pointing to an actual field.
***Both the New UI and Classic UI***
The user/admin will need to drill down one or more times in the "Aggregation Field" until a field is selected.
Ex) SLA definition -> SLA Definition fields -> Duration