To properly plan resources, I would like to estimate up front how much time should be spent (within certain classifications) on tickets (based on issue type and t-shirt size). I would then like to compare to actual hours logged by employees. Example: an XL Story should need 15 hours of 'Requirements Gatherings', 3 hours of 'Design Review,' 30 hours of 'Development', and 15 hours of 'QA / Testing'.
When employees log time (using Tempo plug in) they currently choose a worklog attribute that aligns with one of these time classifications. I have the idea to create 4 numeric value fields - one for each of these classifications of time logged. I would like to use the worklogs submitted to pull hours into one of the pre-defined fields and increment total whenever another worklog is created. Therefore creating a SUM of all 'Requirements Gathering' time logged in one field, a separate SUM of all 'Design Review' time logged in another field, and so on for 'Development' and 'QA / Testing'. Is this possible?