How to create an Epic pie chart showing last sprint workload

[Ewald Steyn]

Confluence gives the option to create a pie chart showing Epic workloads for the whole project to date. I need this pie chart to show only the epic workload for the last sprint 

[Jack Brickey]

I’m not aware of any way to reference the “last sprint”. While you can query to show active or inactive there is no “last”. Maybe you could leverage a custom field (closed in last sprint) and set it using automation when a sprint is closed. Of course you will also need to use automation to first clear the field on the previous issues.

[Ewald Steyn]

I will give that a try and get back to you, thank you for the response.