Report fun: tallying and averaging the days between steps in the sales cycle

• Question

• 

  

  0

  Sign in to vote

  Here's what I've got:
  
  I've seven steps in the sales cycle for my roofing company:
  1. Inspected
  2. Contracted
  3. Adjusted
  4. Negotiated
  5. Approved
  6. First funding
  7. Production
  
  And I need to write a report that averages the time in days a roofing jobs take to move through the process. Jobs are Opportunities.
  
  Even cooler would be to pick a date range and see that for the jobs that were Contracted in that range, they took 5 days to be adjusted, another 3 to be negotiated, another 6 to be approved, etc.
  
  The dates of each of the steps are trapped in the Opportunities tab. Does Dynamics even do something like this?
  
  You guys rock.

  • Moved by Xiaopeng Wu Tuesday, March 8, 2011 11:11 PM Forum consolidation (From:CRM Online)

  Tuesday, September 8, 2009 9:32 PM