Not part of an aggregate function...

[Novaember]

Hello!
I have a quality database where items are scored for quality purposes.

I also have a query that calculates how many items are in the sample, how many opportunities there are for a defect, how many defects there are etc.
That works great when I am running that for the entire process type.

However when I want to run that query for each individual in the total sample I can't seem to figure it out.

I just want to use the exact same query and add in "CompletedBy" and have the results display all of the calculated values for each user.

so the output would be like:
completedby, total items sampled, total opportunities, total defects, total incorrect products, accuracy rate, defect rate.

When I try to put in the completed by part I get:
"You tried to execute a query that does not include the specified expression 'CompletedBy' as part of an aggregate function."

Maybe my brain is not functioning up to par this morning but I can't figure it out. I don't want the user to have to input the Completed By name. I want it to read what is in the sample and output the results by Completed By.

Any suggestions?

Thanks for the help!
~Nova

 

[gemma-the-husky]

make completedby a "groupby" in the appropriate section - does that work?