greenstreetsinitiative / checkin2015

The new and updated version.
5 stars 14 forks source link

Change the company size categories for the Leaderboard per https://docs.google.com/spreadsheets/d/1DHnLWudZASrq3OpwcErvzmWQZe35APoCG6m-HTd2CT8/edit#gid=1578474800 #93

Open jkatzchristy opened 7 years ago

jkatzchristy commented 7 years ago

We need to have different size categories for each year or provide another way of still showing previous years' dashboards. Ie. one category in 2016 was called "Biotech and Banking" in 2016, and now is "Biotech". So last year's sectors don't make sense for, eg. State Street Corp. being in "Biotech". And last year's size winners no longer show that they won, as size categories have been reconfigured. We need to be able to change sector categories and size categories but have them remain appropriate on their year's leaderboards.

rrballenger17 commented 7 years ago

The category sizes for 2016 are restored. I'll check if the 2015 category sizes also need updated.

I'm working on restoring the 2016 category names. It's probably easiest to do it manually in the app code versus adding it in the database. Plus, past years category names will never change.

rrballenger17 commented 7 years ago

Based on a data backup from March 8th, last year's categories were:

id,name 1,Biotech and Banking 2,Hospital and University 3,Public and Municipal 5,Sm Technology Co's 6,Architecture and Engineering 7,Legal and Development/Education 4,Technology, Energy, Media, Co-Working