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".
Sorry it's only slightly related, but hopefully it gives you some ideas.
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 firstname.lastname@example.org and describe how this metric should be calculated.
Ilze, eazyBI Customer Support Consultant
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...
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