How do I create a formula in Structures to identify committed work in a sprint?

[Barry Mazin]

I am trying to show what work was committed in a sprint and what work was moved out while the sprint is active on a Structure chart?

I can write a query to insert the issues on the active sprint onto the structure.  However, I can't figure out how to write a formula to show what work was committed at the beginning of the sprint and what work was moved out during the progress of the Sprint.   Is there a way to do this?   

My goal is to show our team's Sprint progress throughout the Sprint and to make sure we are focused on the appropriate work. 

[Dave Rosenlund _Trundl_]

Hi, @Barry Mazin 👋

I moved your question to App Central, where questions about Atlassian Marketplace products, like Structure, should be posted. Also, I added additional tags to hopefully draw the right eyeballs to your post.

That said, I suggest you contact the Structure support team at Tempo directly for a faster response time and resolution.

Best of luck,

-dave

P.S. If you do get a solution from Tempo support, it would be great if you could come back and share it here so others can benefit in the future.

[Thuan, Do Dang]

HI @Barry Mazin ,

You can access Report > Burndown chart. You can see what you have from the start of the active sprint and what was done, removed, added to the sprint on the chart or on the issue list below the chart.

[Barry Mazin]

I realize that we do have that report, but my goal is to use the report to make it easier for individual team members to talk about what they have accomplished in the iteration review process and to explain some of the decisions that they had to make with the work that they had originally committed to.