+ Start a Discussion
Subhash GarhwalSubhash Garhwal 

How to create a report that show Average number of new opportunities created per week by a user

Hi All,

I need to create a report that show Average number of new opportunities created per week by a user.

Ex. 50 total opportunities created in this Month
    User A :- Creates 10 : 1 record in 1st week, 5 records in 2nd week, 4 records in 3rd week, 0 records in 4th week
    User A :- Creates 25 : 10 record in 1st week, 5 records in 2nd week, 5 records in 3rd week, 5 records in 4th week
    User A :- Creates 15 : 0 record in 1st week, 5 records in 2nd week, 5 records in 3rd week, 5 records in 4th week

    so,
    Average number of new opportunities created per week by User A : 2.5
    Average number of new opportunities created per week by User B : 6.25
    Average number of new opportunities created per week by User B : 3.75

Regards
Subhash