Forum Discussion

matpj's avatar
matpj
Frequent Visitor
6 years ago

Azure DevOps Open Bug Trend

Hi there,   I'm sure this must have come up countless times but cannot seem to find anything. I am using PowerBi and I want to plot a line graph showing the number of open bugs each day or week ov...
Need Help
Tutorial Requests
matpj's avatar
matpj
Frequent Visitor
6 years ago

Thanks Amy,

they are useful links.

 

one of them is pretty close to what I wanted to do - but different in that I want the number of currently open bugs as a trend, with the count of opened and closed represented as a bar chart.

I guess they could be lines also - but they are more distinct values (opened/closed).

However, if I use a simple analytics view for this - I have to filter it based on open states (to show the outstanding line) which means I don't then have the count for each day of those opened and those closed

 

any further ideas?

 

thanks,

Matt

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Did you eer find a fix for this?  I have tried several things, even using an analytics report with only bugs and story history for the last 30 days and it still doesn't graph correctly.  It shows stories opened much longer than 30 days ago which defeats the purpose since I want to know, how many were "opened", "closed" and what remains "not closed" on any give day in the last 30 days.

  • bunny18's avatar
    bunny18
    Helper I
    6 years ago

    anyone got the solution. ? Appreciate if you could share. I am also looking for plotting charts in Power BI using the analytics bug history data from Azure DevOps. Basically, a Total Inflow, Total Outflow, Open bugs.