Extracting bug metrics from Launchpad

[Jones, Bruce E]

I'm being asked by management to provide bug count metrics for the StarlingX project.  Our LP instance is at https://bugs.launchpad.net/starlingx.

They are looking for things like "average age of closed bugs", "# bugs closed per week" and so on.

There doesn't seem to be a way to gather this kind of data from Launchpad.  Some of the items needed like "bug creation date" aren't visible in the UI and may not exist in the database.  I can't search using date ranges in the advanced search.  If I could export all of the bug info into a spreadsheet I could just pound it out, but I can't see how to do that.

Even better would be to extend our project's bitergia page https://starlingx.biterg.io/ to show some of these metrics.  But I'm not sure how to do that or if it's even possible.

Thoughts and suggestions would be greatly appreciated.  Thank you in advance!

         brucej
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opendev.org/pipermail/service-discuss/attachments/20200417/cff5decf/attachment.html>