Develop annual output table of global proportions from Equity Landscape inputs which have been making appearances in quarterly learning sessions
Output-side global proportions in the form of should be tabled by location and year for:
- population
- internet population
- pageviews
- unique devices
- editors
- active editors
- grant dollars (weighted and unweighted)
- grants
- grantees
- operating affiliates
- primarily located affiliates
Each proportion should be based on the location's count over the global count as denominator to produce percentages for each location that sum to 100% with the exception that, for operating affiliates, the denominator should be total affiliates (rather than total operating hits) and the sum across locations will exceed 100%.
Source tables and data:
population_data_input_metrics
- population
- internet population (Note: for this we need to multiply total population_annual_signal by (internet_percent_annual signal/100) for each location first to produce the internet population count and then take each over the sum of those internet population outputs)
georeadership_input_metrics
- pageviews
- unique devices
geoeditor_input_metrics
- editors
- active editors
grants_leadership_input_metrics
- historical grants count
- historical unique grantee count
- historical grants dollars unweighted
- historical grants dollars weighted
- annual grants count
- annual unique grantee count
- annual grants dollars unweighted
- annual grants dollars weighted
affiliate_data_input_metrics
- operating affiliates (using operating_countries)
- primarily located affiliates (using country_code)