Track the remaining work for a team

Question

My requirement is to show the remaining work of the team after the Sprint is completed and track the value for past five Sprints.

I would like to know is it possible to create a custom field , generate the value for the custom field using the JQL function and store them .

If i use above approach do i need to create custom field for every team ?

Let me know if there are any other better approach for this requirement

Currently i generate the remaining sum by running below query

issueFunction in aggregateExpression("Total Estimate for all Issues", "originalEstimate.sum()", "Remaining work", "remainingEstimate.sum()")  and issueFunction in previousSprint("Olympians Board for Story")

Walter Buggenhout · Answer

So each team can track its own report. Do you have different versions per team because teams work across different Jira projects in one board? Or is their a different reason for that (my last question to understand your situation, I think)?

Manikandan K · Answer

@Walter Buggenhout-We do have seven teams and each team using their own board

Walter Buggenhout · Answer

If you are using a single board, how do you define your different teams?