search

dllh / kcs-tracing.org

0 stars 0 forks source link

Check logic of school-specific date display #5

Closed dllh closed 3 years ago

dllh commented 3 years ago

School-level charts show last 30 days through 8/30. Can we make that automatically adjust so you don't have to manually change it each day? (Main chart shows through 8/31.)

dllh commented 3 years ago

I'm pretty sure this is working as expected. H mentioned having added dates after August 30, but I know two of these were future dates, and the query looks for data between the current date and 30 days prior, so future dates would not have been included. There was one data point for today, but it was for another school and is showing up for me.

I added a new case from before today and after August 30, and it showed up as expected.

I have updated the query to use NOW() rather than CURDATE(), as that'll assure that we pull in results right up to the current moment.