Hi all, this has been asked many times but I can't seem to do it
So I have a table where people record the following information:
name (selected from ref to another table) - Labor (selected from another table - Amount of clamshells harvested (#) - hours (#). I need to find the average number of clamshells harvested per hour by each employee and average number of clamshells packed by each employee.
โHere is the formula where I Sumed the total values of clamshells of each person, but dont know how to separate by labor
โ
hi,
just another column avg with [cosechado por empleado] / [# de horas], no ?
this is a groupby in view on labor and empleado where u see the avg you want.
User | Count |
---|---|
41 | |
31 | |
31 | |
16 | |
14 |