[Dashboard] Sectors not counting correctly

[btornes]

Per Robert in this Basecamp thread:

I noticed that the sector count (in parentheses) appears to be counting differently than the other counts. The counts should be tallying the number of unique countries/sectors/donors, etc.. The sector count is counting the associations rather than the sectors. For the example org in staging, there are three sectors used, so the count should be 3, not 4.

http://office.ngoaidmap.staging.vigetx.com/admin

[RBFraxinus]

Looks like this is something I can tackle. There are a few other counting issues on the dashboard as well, with countries.

There is subtle flaw in the calculation of countries for organizations/projects. I noticed the query on the dashboard is using "where('adm_level => 0')", which only gets relations for projects that are only linked at the admin 0 level. This misses all records where more specific location information is provided; in those cases, the relation admin level would be 1,2, or even 3. This can lead to under-reporting the countries associated with a project or organization.