Context: A healthy open-source software (OSS) community is one that has a diverse contributor base and is sustainable by retaining its contributors. Project leaders, therefore, must understand their community’s turnover and diversity makeup.

Objectives: This study aims to investigate how to support project leaders in monitoring OSS community health. Specifically, we examine the role of an interactive dashboard in enhancing awareness of contributor turnover and diversity.

Methods: We designed and developed Community Tapestry, a dynamic, daily-updated dashboard, using Participatory Design (PD) sessions with stakeholders from the Apache Software Foundation (ASF), Community Health Analytics in Open Source Software (CHAOSS), and Bitergia Analytics. We initially evaluated Community Tapestry by engaging contributors from our PD partners’ OSS projects. To further validate our findings, we conducted a confirmatory study with a prominent OSS project under the Cloud Native Computing Foundation (CNCF). Contributors from both projects explored a personalized version of the dashboard that uses their own up-to-date project data.

Results: Our results demonstrate that Community Tapestry enhanced participants’ awareness of their community’s turnover and diversity state. It enabled them to identify areas for improvement and provided actionable insights to foster a more inclusive and stable community.

Conclusion: Community Tapestry offers OSS project leaders an actionable approach to monitor turnover and diversity state, enabling data-driven governance and fostering more inclusive and sustainable communities. Our PD approach provides practical insights into how community-driven interventions can be developed and adopted.