search

microsoft / vsts-extension-retrospectives

An Azure DevOps extension for efficient retrospectives
MIT License
183 stars 82 forks source link

Ability to report on team assessment data using Analytics Views #651

Open wesfincher opened 9 months ago

wesfincher commented 9 months ago

We have been tracking our team retrospectives for some time. I've built some rudimentary visualizations to easily see these over time. I would like to report on our team assessment summaries in PowerBI rather than having to open each retro manually and copy that info into Excel. Is there any possibility of retrieving this data via API or Analytics Views?

image image

kjerstidri commented 8 months ago

I would also like to know if there are ways to track this data and check trends over time. Maybe there is an option I have not fund yet?

cgrippon commented 1 month ago

Hi @wesfincher How did you create this vizualization ?

wesfincher commented 1 month ago

@cgrippon - I manually typed those values into excel and inserted a chart to configure the visual. I know, it's high tech. Which is exactly why I'd like the extension to provide these kinds of reports or make the data available so I can build more sophisticated Power BI reports.