Forum Discussion
Query based pie charts in Azure DevOps - how do I display a percentage rather than a count?
Hi,
I created several charts to track the progress of bugs and test cases. I will use the following two as examples:
1. Open Bugs by State: please reference attached - this chart shows the count of open bugs in each state.
2. Test Case Results by State: please reference attached - this chart shows all the test cases created, pivoted by state.
Is there a way to display percentages for each pie slice, rather than the count? For example, in the Open Bugs by State, rather than showing Open = 18, can I display "72%" (18/25)? Right now when I configure the chart, I see the "Aggregation" option, but this only allows me to choose "Count". Do I need to update my queries somehow to get a %?
Thank you for the assistance!
- Jean-luc7636Copper Contributor
I keep getting an error that the Query cannot be in Hierarchical.
When changing the state to Flat - I simply get a Widget failed to load.
What would be the Query to show Story Case by States?