Regarding non-availability of Project Management Chart
Our company has recently introduced Azure DevOps to streamline project management process. Currently, 140 projects are created under our organization in Azure DevOps. As and when requirement comes from client for any specific project, we create tasks/bugs for different developers under that project. Currently we use only two Work Item type - Bug and Task. Now the issue is Management of the company wants to see Project-wise number of "New/Open", "Active" and "Closed" Tasks and Bugs in a SINGLE chart. That means, that single chart must fit consolidated data of 140 projects. If a person views that single chart they must get idea, for example that - Project 1 has 2 new/open work items, 2 active work items and 2 closed Work items , Project 2 has 1 new/open work items, 10 active work items and 3 closed Work items and so on.. This is done so that management in a glance can understand which project is lagging behind for customer delivery. So that they can work accordingly build more manpower for those Projects.
I have tried to create various such charts and widgets with different queries in Azure DevOps. I used widget burn up and burn out charts but it gives data for tasks of single Project only. Also when we add multiple projects to it, it shows summation of completed/remaining tasks for those Projects & NOT Project name-wise completed/remaining tasks bifurcation. I also tried "Charts for work item" widget but it also fetches count as per- Assignee, State and Work Item type and not project name wise count is fetched.
I don't want to navigate through 140 projects pages to see it's open, active and closed tasks. So please help me out in suggesting the ideas on How can I build a single chart from where we can get all this data? I will be forever grateful for your answers. Thank you!
You could create a query across projects, select Team Project column in Column option, ad save the query as shared query. Check the screenshots below:
Then add a chart widget to a dashboard, select Pivot table, and set Team Projects, State as Rows and Columns. Check the screenshot below:
You could expand the view to see more details:
- How can I remove particular tools in TradingView widget JS?
- Transpose Excel data for multi-Stacked bar chart
- Dynamically update values of a chartjs chart
- Show y axis lines even though all values are zero
- Excel VBA chart data label position property update delay after chart layout change
- Vega chart center bar in dynamic number of columns
- Command-line Unix ASCII-based charting / plotting tool
- Create a scatter in excel using vbscript
- Stacked and column bar chart
- How to format Chart.js dates in the axes and tooltip
- Error when trying to use addRange in Embedded Line Chart Builder
- What is the proper way to include chart.js with Nuxt 3.4?
- How to update a chart in Google Slides dynamically?
- Is ZedGraph library development still active? If not - are there any open source replacements?
- Display dataset in Horizontal bar with offset in the Excel?
- Need to force specific colors to specific values of a field in a ggplot geom_col chart
- Blood Sugar Chart for Two Diabetic Cats in Google Sheets
- Percent pie chart with css only
- Vega-lite Gradient: Specify Where the Color Changes Relative to the Axis Scale
- nivo.rocks painting chart unproperly with line not corresponding to X-Y
- Set Color codes to the legend text in vba?
- Apexcharts download chart as an image (PNG) when external button is clicked
- Chart JS text centre in doughnut chart
- SwiftUI Charts Annotation issue
- How to color different segments of plotted curve based on value
- Draw horizontal line on chart in chart.js on v2
- Problem with drawing a chart in Visual Studio
- How to set height of individual bars in Ant Design Stacked Bar?
- Label wrapping with stacked bar charts
- Set the x axis limits (min and max) on categorical scale