I am working on producing a daily Turn-around time/ Task response -mail summary report.
I understand that the OOTB reporting feature of Approver Performance Statics Reports contains a summery but what I need is a monthly rolling report for a specific task type that can be sent and e-mailed daily.
I have the html table format and the beginning steps,query the list, get the date difference (assigned date - end date), round them off but I cannot for the life of me figure out how to add all of those tasks up and get an average. I tried the collection operation Add and the run-time function of average but they don't seem work.
Is what I'm trying to do possible, if so can someone help me understand what I'm missing?
Thanks in advance!