Forum Discussion
Is it possible to define and visualize new metrics (e.g. ratios) in dashboard widgets in Azure DevOp
Yes, it is now possible to calculate custom metrics (such as ratios, percentages) in ADO by using the widgets offered by Great Gadgets extension available in VS Marketplace: https://marketplace.visualstudio.com/items?itemName=StonikByte.stonikbyte-great-gadgets-extension&ssr=false#overview
This extension offers an Advanced Issue Filter Formula widget that fully covers your second use case "ratio (Count of WorkItems with priority 1 or 2) / Count of all WorkItems".
This is an example:
To obtain this, the widget should be configured like this:
The widget uses the count of multiple shared filters stored in variables a, b, c and then you combine these values in a formula you want (a+b)/c * 100 to obtain the ratio.
Very useful can be also the Pivot Table & Pivot Chart widget offered by the same extension.
Hope this helps.
D.