select * from qmd_links where dateonly =

Total Goal/Actual - #val( _totalGoal )# / #val( qmd_links.recordCount )# (#_totalPercentage#%)

Total Gaps (> 15 minutes): #_structCountGap#

Average Gap: #numberformat( arrayAvg( listToArray( _avgGaps ) ), "00" )# minutes

Avg Daily Goal/Actual - #_dailyGoal# / #numberformat( _avgDailyActual, "00" )#

select min( ma.eventTime ) eventTime from tbl_TRK_MemberActivity ma inner join tbl_FSPRO_Members mem on ma.fspro_userId = mem.fspro_userId where mem.email = and cast( eventTime as date ) = select * from qmd_links where dateonly = select min( fsl_choIdDate ) mapTime from qmd_linksPerDay select max( fsl_choIdDate ) mapTime from qmd_linksPerDay

Today#dateFormat( i, 'mm/dd/yyyy' )#

First Mapping: #timeformat( qmd_first.mapTime, "hh:mm tt" )#

Last Record Mapped: #timeformat( qmd_last.mapTime, "hh:mm tt" )#