resident load invalid expression

[drohm002]

Hello, can anyone tell me why I am getting an "invalid expression" error when i load the script below?

[dncontin · Accepted solution]

try

GROUP BY
[Report Finalized By],
[Finalized Date];

[Amit_Prajapati]

Hi @drohm002 ,

You're performing an aggregation operation using COUNT(Internal Exam Id).

As per @dncontin  guidance, when applying any aggregation, all remaining dimension fields must be included in the GROUP BY clause. In this case, please ensure the following fields are grouped:

[Report Finalized By], [Finalized Date].