Apex Code Development You need to sign in to do that
Don't have an account?
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
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