Forum Discussion
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 recomme...
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.