We have a few teams logging time and others don't (and never will). We are trying to get an understanding of how much time different project types take from everyone in our group, not just hours from those that log time. So I'm trying to think of a 'common denominator' way to associate average hours per project type. We have project type as a multi-select checkbox question on our project form. I thought about using values in the checkbox field (label for project type, value for avg hrs). However, when using a calculated field in reports, it uses on values, so then when I group by this type it's showing as values (numbers) instead of the labels (name).
Does anyone else have any other ideas on how they capture estimated overall time on projects to account for teams that don't log time?
If this helped you, please mark correct to help others : )