March 2023 update - PR Data, new filter syntax, and more!

[ahpook]

Hello from GitHub OSPO! @ahpook here with a product update for the Organization Metrics Dashboard. We've been hard at work making usability and functionality improvements based on your feedback, and I'm excited to share details about some recent ships.

First and foremost, we've added Pull request data – by far, the most requested feature for the dashboard. In the data table, you can view and sort by:

• the number of currently open PRs in a repo
• the ratio of PRs merged to those closed without merge, as a percentage (higher is generally better)
• the average time between a PR being opened and closed, independent of whether it was merged or not

There's also a new flyout graph that visualizes the number of PRs opened, merged, and closed without merge over time.

The "headline" cards at the top of the dashboard which group repositories by their recent activity are now clickable. Selecting a card will filter the table down to show only repos matching the date criteria. You can also adjust the date ranges in the filter input manually to show a different slice of your repos. This uses the same date-range syntax as other GitHub filter dialogs, which supports AND'ing multiple date conditions together to get as granular as you want.

In order to make room for the PR columns in the data table, we also made a few adjustments to the data displayed there. We removed the confusing "external contributor" metric and adjusted the way the header row works: clicking the repository name now takes you to the repo's homepage, while clicking the 'graph' octicon in that column will open the flyout sidebar.

Speaking of the sidebar, it now sports a summary of the repo's community standards like README, License, and Code of Conduct right at the top. The selectors for graph period and timescale now use consistent UI components, and there's a contextual description of each graph, derived from the CHAOSS community metrics.

There have been a few great discussions (both in person and in the community/ospo forum asking for more transparency around the methodology behind the metrics. To that end, I've added a new section to the dashboard documentation page with some details about the date calculations, contribution activity, and more.

Looking ahead, the next big item is API access. We've heard from a number of you that it'd be awesome to incorporate these metrics into your own dashboards, combine them with internal data sources, and generally deal more programmatically with this information. To that end, we're looking at exposing as many of these metrics as possible through supported GitHub APIs. Look for more on this in the coming weeks.

We'd love to hear feedback on how these changes are working for you! Please let us know if you run into issues or have additional use cases you'd like to cover.