It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage
  • Community
  • Products
  • Marketplace Apps & Integrations
  • Questions
  • what should be the calculated member for a report in EazyBi for average velocity for past sprints. I want to tabulate it as the following columns-"project", "Average Velocity", " Estimated number of sprints left based on velocity"

what should be the calculated member for a report in EazyBi for average velocity for past sprints. I want to tabulate it as the following columns-"project", "Average Velocity", " Estimated number of sprints left based on velocity"

 

2 answers

I think using EazyBi for this is being overly complex.  Why not just use the built Agile burndown charts?  You need to specify a start and end date for your release and then you'll get a velocity line with a projected end date.

If you're set on using easy BI, have you started with some more basic concepts?  I need a report to break out productivity by team.  I used the custom numeric field "LOE closed" (I think this was supplied by my particular version of JIRA, not created by me) with rows "Sprint" and "Issue".  This allowed me to plot LOE closed per team sprint.  If you want to provide the estimated number of sprints left based on velocity you would probably need to change what I have in "Pages" from "Project" to "Fix Version".

 

 

image2016-10-27 9:58:15.png

Sorry it's only slightly related, but hopefully it gives you some ideas.

Hi!

You can take a look on example report "Sprint velocity chart" in eazyBI demo account: https://eazybi.com/accounts/1000/cubes/Issues/reports/61946-sprint-velocity-chart.

There is used a calculated measure "Running velocity for 5 closed sprints" which calculates the average velocity based on last 5 closed sprints. You could create a similar measure in your account or even use this report as a base for yours (then export it and then import to your account).

 

For assistance with "Estimated number of sprints left based on velocity" and further report elaboration, please, contact support@eazybi.com and describe how this metric should be calculated.

 

Best regards,

Ilze, eazyBI Customer Support Consultant

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Marketplace Apps & Integrations

Expose your beautifully crafted Dashboard through the Jira Service Desk Customer Portal

  A picture is worth a thousand words, especially when you're trying to find relationships and understand your data. Here, Dashboards play a vital role in gaining insights from a variety of dat...

296 views 5 4
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you