QualityMap select sitename, round(strftime('%s', time)/:span)*:span as time, sum(case pass=1 when 1 then 1 else 0 end) as passing, sum(case pass=1 when 0 then 1 else 0 end) as failing from GridScan where sitename like :facility AND time >= :starttime AND time < :endtime group by sitename, round(strftime('%s', time)/:span)*:span 2009-07-04 05:01:47 604800 2008-07-04 05:01:47 % /gratia/xml /gratia/static/content /gratia/gridscan_graphs/gridscan_quality?endtime=2009-07-04 05:01:47&span=604800&starttime=2008-07-04 05:01:47&facility=%& Successful Failed