Hello!
I asked this question long ago, but the answers were more directed on solving the problem on the dashboard, rather than the script, and at that time I choose to do that, but now the data base has grown a little bit more, and I think it will grow even more, so I need to do this on the script.
The problem is this: Every month I need to count the exact number of employees per user tittle, that are working in the company, this is only the first step to do other calculations, so it need to be accurate. The issue appears when I have more than one user tittle -it should be always only one-, attached for one employee, in those cases I need to see which one of the two has the most working hours and then choose that with the higher work load. for example: "John" is a developer, and has been a developer for almost three months :November, December and January, but "John" gets promoted at the beginning of January to supervisor, so in that month (January), I would have two identical emails for "John", one per each user tittle. What I do here is that I look at the "working hours", and I decide what "Jhon" was based on that, here lets say that "Jhon" reported only 30 hours for developer and the rest of the 160 (that is 130 hours), are reported as supervisor, so under the light of this evidence, the developer "John" would get erased and wont be counted as an employee.
Please Help me, I am attaching the file with the data.
Thank you very much.
