Forum Discussion

danielmoncadal's avatar
danielmoncadal
Copper Contributor
Jul 17, 2023

Operations between queries in Dashboards

Hi community. 

I would like to create a dashboards with the results of operations between queries in AzureDevOps.

Example: 
(Result query 1) x  (Result query 2) / 10

Do you have any recommendation to do it? 

Thank you

azure devops

1 Reply

  • Kidd_Ip's avatar
    Kidd_Ip
    MVP
    Aug 25, 2025

    May try below as workaround:


    1. Use External Tools (Power BI or Excel)
    •     Export your queries using the Azure DevOps Analytics extension.
    •     Connect Power BI or Excel to the Analytics view.
    •     Perform your calculations there and publish the dashboard externally or embed it.
    2. Custom Widget via REST API
    •     Use the Azure DevOps REST API to fetch query results.
    •     Write a custom widget using Azure DevOps Extension SDK.
    •     Perform your operations in code and display the result in the widget.
    3. Scheduled Script + Markdown Widget
    •     Run a scheduled PowerShell or Python script that:
    •     Pulls query results via API.
    •     Calculates the desired value.
    •     Updates a Markdown widget on the dashboard with the result.

Resources