azure-devopsdashboardsprint

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?


Solution

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