Hi,

I'm trying to establish a template that will do the following:
  • Read/Count data that falls within specified dates - Either weekly &/or Monthly
  • Find its task owner & the following:[INDENT]How many tasks assigned
    Within given week &/or month also find status if "On-Time", Day(s) Late & total number of tasks[INDENT]

Off my task log, I'll should have or trying to establish the following breakdown results:

Multiple task owners
4 Primary Task statuses of:
Total tasks assigned (no date criteria)
Total tasks assigned within given date criteria (weekly &/or monthly)
Status of deliverables - "On-Time" or "Late"



Does anyone have a good matrix type of template that works well for charting? If so, please provide example template (with chart).


Thank you.