JQL to calculate the completion rate of last 3 sprints

[Núria Rull Bassols]

Hi,

I'm currently calculating the completion rate using an Excel file, and it works well. However, I'd like to enhance our dashboard by creating a chart using the "Custom Charts By Tempo" app, which allows chart creation with JQLs.

I've already created a chart using two JQLs to represent the completion rate for a single sprint:

• Sprint 1 planned: Sprint = 2256
• Sprint 1 completed: Sprint = 2256 AND status was Done during ('2024/04/24','2024/05/08')

Is there a way to combine the planned and completed items in a single JQL? Additionally, is it possible to create a JQL that includes the last three sprints? I couldn't find any relevant information on this.

Thank you.

[Dave Rosenlund _Trundl_]

Hi, @Núria Rull Bassols  👋

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

That said, I suggest you contact the Custom Charts support team at Tempo directly for a faster response.

Best of luck,

-dave

P.S. Also, if you do, it would be great if you could come back and share the solution here so others can benefit in the future.