Thanks in advance for any help you can offer.
I’ve been wracking my brain for the past week, trying to figure out how I can calculate my teams hours spent on a particular job type.
I’ve imported our teams hours from our time tracking software via CSV file. Right now, I have the items grouped by Client > Project. I’ve filtered by “Project contains > web” Within is also how many hours were spent on that job. These groups are able to tell me the sum of all the hours, per group. What I need to know now, is how to calculate the average amount of time spent on a certain job type, for example, “web design”.
Like I said, been trying this for quite a while, with no results. Any help is much appreciated.