Group Service Request weekly results starting on Mondays instead of Sundays

[danxoneil]

The City publishes Performance Metrics for all sorts of service requests (but they don't break them down by ward).

Example: https://data.cityofchicago.org/Administration-Finance/Performance-Metrics-Transportation-Street-Lights-A/phrs-x2nm

As you can see, all of these weeks start on the Monday (example, Row 11, June 6 - 12, 2011, where there were 563 total Street Lights All Out requests closed)

Our corresponding page: (http://chicagoworksforyou.com/service/street_lights_all_out/#/2011-06-11/) is for the June 5 - 11, 2011 time period, and we have 592 total Street Lights All Out requests closed.

If we lined these up, it would serve as pretty cool smoke test for matching up the two systems.

[cgansen]

this is a great flag. Awesome.

On Fri, Aug 30, 2013 at 9:51 PM, danxoneil notifications@github.com wrote:

The City publishes Performance Metrics for all sorts of service requests (but they don't break them down by ward). Example: https://data.cityofchicago.org/Administration-Finance/Performance-Metrics-Transportation-Street-Lights-A/phrs-x2nm As you can see, all of these weeks start on the Monday (example, Row 11, June 6 - 12, 2011, where there were 563 total Street Lights All Out requests closed) Our corresponding page: (http://chicagoworksforyou.com/service/street_lights_all_out/#/2011-06-11/) is for the June 5 - 11, 2011 time period, and we have 592 total Street Lights All Out requests closed.

If we lined these up, it would serve as pretty cool smoke test for matching up the two systems.

Reply to this email directly or view it on GitHub: https://github.com/smartchicago/chicagoworksforyou/issues/241

[santheo]

Okay so the directive is to make all week views start on Monday? This may be tricky (or at least trickier than just changing one variable), but I can do it.

[santheo]

Just please first confirm I should go ahead with this.

[danxoneil]

OK let's chat about it. There's a goodly amount of work to do, and I don't want to prioritize a noodling exercise.

-- It would be very cool to have a one-to-one comparison of the City's performance metrics and our pages. -- The City seems to have standardized on Mondays as the start of the week -- This also makes sense from a work week point of view -- Having said that, the City doesn't even keep up its reports for some types: https://data.cityofchicago.org/Administration-Finance/Performance-Metrics-Streets-Sanitation-Rodent-Bait/ga2y-gwbs -- (The last week shown there is July 2 - 8, 2012 and there are no weekly counts) -- So the magical relationship will not always exist -- Moreover, we have other, more visible and important tasks (social sharing being one of them)

Question: how much time would it take to do this?

[santheo]

Could be anywhere from 15 min to 1 hour. I won't know for sure until I start digging in.

I do think it's a good idea, overall. Right now we split up consecutive Saturdays and Sundays, but we like to think of weekends as cohesive units, and as big citywide service-influencing events go, sometimes they happen on both days and it'd be good to seem them together.

[danxoneil]

OK yessir PleaseDoSir.

[santheo]

Okay that wasn't too hard. About a half-hour, including the work to update the homepage headline to include the day-of-week, which I realized wasn't being shown up to now. Have a look:

http://chicagoworksforyou.com/ http://chicagoworksforyou.com/service/graffiti_removal/

[danxoneil]

perf. Including screenshot for the heck of it.