report of percent up to date as of point in time

[Dan MacNeil]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

 affects mvhub
 assignee nobody
 importance low
 security no
 status confirmed
 tag feature
 done

This report is super useful:

  http://mvhub.com/cgi-bin/mvhub/reports.pl?report_number=4

It would be more useful if the percentages were
as of a point in time.

So instead a report that looked like:

Number & percentage of Agencies & Programs updated in the Last 6 Months

Agencies Programs
198 of 227 (87% ) 531 of 596 (89% )

Date | Agencies| Programs
08-01-2010|.... |...........
08-05-2010|.... |...........
08-03-2010|.... |...........
08-04-2010|.... |...........

01-01-2020|.... |...........

update:
 app-mvhub/mvhub-cron

create:
 app-mvhub/bin/update_percent_update_snapshot

 table: percent_uptodate_snapshot
           date
                  agency_count
                  agency_percent
                  program_count
    program_count

see:
   app-mvhub/setup/database/README

As a huge bonus, draw a scatter/plot graph

 DBD::Chart::Plot

with Dates on X-axis and % up to date on Y
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkwzRk8ACgkQeAqU5YwjhK+BkgCcCqk/v7Eppp054pwMVY+RuiOt
HmgAnj7r1x2t73KqnuYNl8t1ztI6Zayb
=16rq
-----END PGP SIGNATURE-----