Hi, I read this page along with https://chaoss.github.io/grimoirelab-sigils/panels/community-structure-by-organization/ and https://gitlab.com/Bitergia/c/FAQ/-/blob/master/how-to-identities/README.md#how-to-add-a-new-organization but I still don't understand where the "organization" data in our Developer Advocacy bitergia dashboard comes from. For example, the Community > Organizational Diversity dashboard lists organizations like WikiWorks, WMDE, Wikimedia, Independent, Google, Wikia, Inc...where is this data coming from?
Topic on Talk:Community metrics
@TBurmeister (WMF) The database contains an "organizations" table (id, name) which includes the orgs and which can be expanded. There's also an "enrollments" table (id, start, end, uuid, organization_id) that stores which user profiles (uuid) were affiliated (organization_id) at which timeframe (start, end). It's manual work to keep this updated, mostly based on SUL username prefixes, email address host names, and other creative non-perfect magic.