Getting from Sprints list the members of each sprint

[Dan27]

Hi,

I would like to run on Sprints list (I made the list with JQL).

On each Sprint I will take the 2 previous sprints.

On each sprint I will run the members that includes this sprint (we can see it better in Structure add-on) and to each member, calculate the field "Sum 3 sprints"= Sum of field "Days in Sprint" of 3 previous sprints of this member.

Example:

sp3 - member X - Days in Sprint 8 - Sum 3 sprints 20

sp2- member x - Days in sprint 2 - Sum 3 sprints Y

sp1- member X - Days in sprint 10 - Sum 3 sprints Z