3 Replies Latest reply: Jun 19, 2011 4:41 PM by Peter Rieper RSS

    How to disassociate activity date from calendar date to calculate number of weeks?

    Ellen Blackwell

      I am trying to calculate the average number of appointments a particular recruiter has had each week. Currently the appointment (appt date) is tied to the calendar date of my generic calendar.

       

      If I select 2010, the distinct # of calendar weeks equals 52. However, if I then select a recruiter, and that recruiter only has activity during 6 months, then the number of distinct calendar weeks is 26.

       

      How can I disassociate the appt date from the calendar date for the purpose of calculating distinct calendar weeks over any given period? In the attached example, select any year, then select a Recruiter.

       

      Any suggestions would be greatly appreciated!

       

      Thank you,

      Ellen