I have created pie chart widget/report to show status of Workshops (custom field) in Azure DevOps 2019:
When I click on Business review (2, Green color) it should show only 2 records in drill down report (or) Query from same pie chart widget. But it is showing all 6 records as shown:
Is it possible to achieve this drill-down functionality in Azure DevOps 2019?
If I modify query it will only show 2 records in Pie chart, which is not I want. I want Pie chart to remain as is & if I click on particular status it should particular records in output/Query like in MS Excel Pivot/reports.
Same way for other ADO 2019 widgets, if I click on particular status/record it should show only that particular record(s) instead of all which is not happening in Azure DevOps 2019 reports/widgets.