Long title but I didn't know how to express it better.
I have a table that contains:
-Employee names in column 1
-Date of performance in column 2
-Result (numerical) of performance in column 3
I need an output that contains:
-one row for each employee
-one column for each month
-average of performance for the employee/month combination in the cells
I would try to solve it like this:
-read employee (X)/month(Y) for the cell in the output table
-loop through all values in column 3
-add to variable A if employee is X and Month is Y
-increase counter (variable B) by 1 for each addition
-calculate average from variables A and B
I don't know if this is practical or too complicated. I don't know yet how to achieve this (I'm working on it).
Any help is greatly appreciated.
I have a table that contains:
-Employee names in column 1
-Date of performance in column 2
-Result (numerical) of performance in column 3
I need an output that contains:
-one row for each employee
-one column for each month
-average of performance for the employee/month combination in the cells
I would try to solve it like this:
-read employee (X)/month(Y) for the cell in the output table
-loop through all values in column 3
-add to variable A if employee is X and Month is Y
-increase counter (variable B) by 1 for each addition
-calculate average from variables A and B
I don't know if this is practical or too complicated. I don't know yet how to achieve this (I'm working on it).
Any help is greatly appreciated.
