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:
- Altair chart mark_text background color/visual clarity
- Highcharts.stockChart is not a function
- Using Highcharts with NextJS, The time (not the date) is repeating
- Plot two series on one chart
- Line chart is not showing and is considered as a part of the column data
- How to draw horizontal Lines using chart.js 3.x ? Cannot get it working
- How do I create a stacked column chart purely through programming with excel vba?
- Is it possible to hide segments in chart.js?
- Dynamically change color of vega-lite area plot based on result of linear regression
- any ideas to create a border radius on a strokecap.butt or strokecap.square in flutter?
- Superimpose plot with background (image) chart
- Chart.js tooltip not showing
- How to set axis limit to a dateoffset from now in Vega Lite
- chartjs datalabels change font and color of text displaying inside pie chart
- Create multiple charts in order of tab of my SpreadSheet
- Dynamically integrate data from Sheets into a Web App to feed a Graphic
- How to omit a year from my axis with value zero
- Create a graph that includes all columns until the last column
- Offsetting the Y-Axis From the Chart, in SwiftUI Charts
- how to hide value axes label am5charts?
- How to avoid chartjs line coming down when adding new value?
- How to change value in tooltip charJS
- How to hide value in Chart JS bar
- How to change the background color of Anchore
- how to not let google chart width size shrink if screen size small
- Polar Bar Charts with Color maps in Python
- How do I dynamically set the scale of y-axis for c3 chart?
- How to show info view on top of specific bar in a grouped bar chart in SwiftUI using Swift Chart framework
- Not able to get action on tap of bar and X axis label in Swift Charts in SwiftUI
- Subgraph doesn't appear in graphviz chart