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:
- 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
- Superimpose plot with background (image) chart
- 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
- How to configure how many ticks Upgrade to 4
- Pie chart (or Donut chart) with 3 levels in R
- In a callable function to create a line chart I need to conditionally change the axis and line width of a series for which the series number can vary
- Cross-hatched (Striped) BarMark in SwiftUI
- How can I align BarMarks in SwiftUI Charts?
- Inserting TextAnnotation in graph c#
- Making chart from react e chart fill the parent container
- How to get min and max vAxis and vAxis ticks using mm:ss in Google Charts API?
- How to choose which columns are used in Google Visualization chart and avoid 'All series on a given axis must be of the same data type' error
- Chart.js - Alignment of 0 values for multiple datasets