select * from qmd_links where email in ( )
(Team) Total Goal/Actual - #val( _totalGoal )# / #val( qmd_links.recordCount )# (#_totalPercentage#%)

Total Gaps (> 15 minutes): #_totalGapsCount#

Average Gap Time: #numberFormat( _totalAvgGapTime, "00" )# minutes

Total New Records (U/I): #val( _totalUAddsCount )# / #val( _totalIAddsCount )#
(Team) Avg Daily Goal/Actual - #_dailyGoal# / #numberformat( _avgDailyActual, "00" )#
Overall Total - #_overallTotal#
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 ) =

Today#_date#

First Record Mapped: #timeformat( _firstMap, "hh:mm tt" )#

Last Record Mapped: #timeformat( _lastMap, "hh:mm tt" )#

Total Goal/Actual - #val( _dailyGoal )# / #val( _totalLinks )# (#_totalPercentage#%)

Total Gaps (> 15 minutes): #_gapsCount#

Average Gap Time: #numberFormat( _avgGapTime, "00" )# minutes


Total New Records (U/I): #val( _totalUAdds )#/#val( _totalIAdds )#

New 1FS Map Only TTL Recs
#_linkUser# #_daysStruct[_date][_linkUser].newRecords# #_mapOnlyRecords# #_daysStruct[_date][_linkUser].totalRecords#
Total #val( _totalAdds )# #val( _totalMapOnlyRecords )# #val( _totalLinks )#