I have been trying to find a simple report for my dashboard that takes a feature with all its sized work items and allows me to assign a average velocity to work out the predicted date of completion of the feature.
Right now I am having to;
copy all the feature's work items into excel
sum the effort across all the work items to get a total effort for the feature
divide that effort by a assigned average velocity
this give me my predicted time in sprints
and then add this to today's date to give my latest predicted date as we sprint along
this gives me exactly what I want but the manual process is cumbersome and it would just be better if there was something already available in azure rather, especially as a dashboard view to keep track of, to work this out as above - its a simple view and quite accurate for my team. Is there something already available that I can use or is not available?