Forum Discussion
Is it possible to define and visualize new metrics (e.g. ratios) in dashboard widgets in Azure DevOp
I am creating some Azure DevOps Dashboard visuals. Some of the metrics I want to create do not seem to be included in the built in Azure DevOps widgets. As two particular examples:
(i) I am using a Velocity widget. But instead of showing the sum of Story Points planned and completed, I just want to show the ratio completed/planned for each iteration (i.e a small change, that does not seem to be supported by the Configure Widget options)https://i.stack.imgur.com/0BHVL.png
(ii) I want to show the ratio (Count of WorkItems with priority 1 or 2) / Count of all WorkItems
The "Chart for Work Items" widget provides something close, allowing a visual of a chosen type (Bar, Pie etc) showing the Count or Sum of a field from a query, grouped by another field. But this doesnt allow for a ratio to be calculated.
I cannot find any other widget type (built in, or within the Marketplace) that allows calculation of such ratios. I am sure that there is a way to define brand new widgets, to add to the marketplace, but that is more than I would want to undertake. Also I know that it is possible to pull data from DevOps into a tool like PowerBI, but I would prefer to stay in DevOps if possible.
Is there something I am missing, where in DevOps it is possible to define/visualize new metrics like ratios?
4 Replies
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.
Hey Paul_Sanders1000
I noticed that you also had requests in this http:// https://techcommunity.microsoft.com/t5/azure-devops/velocity-dashboard-widget-showing-totals-for-multiple-teams/m-p/3720595 surrounding velocity. We should be able to help with this at minware using our marketplace integration. Our tool automatically calculates velocity at the task level -- we don't have some of the ratios that you are asking for available today, but we would be happy to build those out for you if you want to share more about your requirements.
Thanks meghanlaclair . Though I was hoping to stay with existing Azure Devops widgets (or those already in the market place) rather than new widgets. We would probably use Power BI rather than develop new widgets.
- Hey Paul_Sanders1000 - there is a new emerging market for engineering analytics and if you are thinking about DIY in-house you should at least take a look at some of the 3rd party services that are out there. Most are plug and play and the market exists for a reason -- ongoing maintenance will cost way more than you think and it's another project to manage that gets very complicated as headcounts and workstreams change.
Happy to provide guidance about which services are worth evaluating if you want to reach out!
