0

My team want to measure the Points Commitment Reliability metric, witch is as simple as the points delivered in sprint vs the points planned to be delivered.

In fact, we have two queries showing it but separately, and we want to know if is posible to have a percentage visualization of the rate of those metrics in Visual Studio Team Services?

Josbel Luna
  • 2,574
  • 3
  • 17
  • 25

2 Answers2

1

Unfortunately, there is not any official widget or chart to handle your requirement.

Since you already created two queries to get related data info. Then as a workaroundm you could export the query to excel, create the chart or table in excel based on your needs, calculate and display the completion percentage.

Just create table/chart in Excel manually to make a division between two queries.

Below articles for your reference:

PatrickLu-MSFT
  • 49,478
  • 5
  • 35
  • 62
  • There is not workarround even using Power Bi connector? – Josbel Luna Jul 23 '18 at 12:04
  • @JosbelLuna Haven't tried this, we do not have this kind of build-in widget. But it's able to Connect to VSTS with Power BI Data Connector, take a look at this tutorial https://learn.microsoft.com/en-us/vsts/report/powerbi/data-connector-connect?view=vsts, you could track the info in Power BI side. – PatrickLu-MSFT Jul 25 '18 at 07:37
  • Didn't update the post, starian's solution works perfect for us because we are already connected with power bi, and querying there is more flexible than VSTS. – Josbel Luna Aug 06 '18 at 23:08
1

You can do it through Power BI.

  1. Connect using OData
  2. Choose WorkItems entry
  3. Expand Iteration record to Iteration.Path.

Then you can filter by Iteration path and work item state.

On the other hand, you can do it programming. Connect using Power Query and Visual Studio Team Services (VSTS) functions.

For example, call REST API by calling VSTS.AccountContents("REST API URL")

starian chen-MSFT
  • 33,174
  • 2
  • 29
  • 53