
Andrew Sowden asked a question.
I have a couple of Apps - Projects, Issues and Timesheets - where an Issue has a single Relationship to Projects for grouping items together.
Within Issues we accrue the Timesheets time into a calculation field called "Actual Effort" that is then used in the Projects app to calculate the Average Time per Issue for the Project.
This all works great !
However - I'd like to automatically suggest an Estimated Time within the Issue based on the selected Project - such that we can have a more "intelligent" estimate as it's based on past experience.
A "Project Average" within the Issue so we can see how each Issue is performing against the Project norms.
I tried a calculation field in Issues using "@All of" etc but I can't get it to just provide the current Project Average Time per Issue.
I've added two screen shots - one of the Project displaying "Average Time per Issue" as 6 hrs/Issue and then the Fields within the Project App.
It's the "6" that i want to refer to in the Issues App when it has the same Project App associated with it.
@Andrew Sowden from the calc field in the Issues app, if you type out the entire "@all of Average Time per Issue" does it appear in the token list to select? If I'm following correctly this should just be a calc field in Issues with an "@all of Average Time per Issue.join()" to pull that numeric value back from the related Project.