Hello All,
Database Use
I seem to have a never ending obstacles in my project. What I am building is a timing database that measures the amount of time an employee spends on Functions. I have about 50 functions available but these functions are spread out to individuals.
Progress
What I have done so far was that I was able to obtain the averages of the functions for Daily, Weekly, and Monthly.
Problem
- I want to find out the average time an employee spends compared too the overall team averages. (I have this in excel as, individual average time / Team average time. then i get where that particular employee stands compared to the whole)
Is this possible? I searched the site and couldn't find an example similar to my problem.
a copy of my report can be found Here
THank you,
Database Use
I seem to have a never ending obstacles in my project. What I am building is a timing database that measures the amount of time an employee spends on Functions. I have about 50 functions available but these functions are spread out to individuals.
Progress
What I have done so far was that I was able to obtain the averages of the functions for Daily, Weekly, and Monthly.
Problem
- I want to find out the average time an employee spends compared too the overall team averages. (I have this in excel as, individual average time / Team average time. then i get where that particular employee stands compared to the whole)
Is this possible? I searched the site and couldn't find an example similar to my problem.
a copy of my report can be found Here
THank you,