CODEWITHSUNDEEP
azure-devopsdashboardsprint
Josbel Luna
Josbel Luna

Reputation: 2814

Is possible to make a division between two queries in Visual Studio Team Services chart?

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?

Upvotes: 0

Views: 1072

Answers (2)

starian chen-MSFT
starian chen-MSFT

Reputation: 33698

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")

Upvotes: 1

PatrickLu-MSFT
PatrickLu-MSFT

Reputation: 51073

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:

Upvotes: 1

Related Questions