Forum Discussion

joeort's avatar
joeort
Icon for Advocate IV rankAdvocate IV
10 years ago

Weight values over time

Has anybody figured out how to do this?   I want to weight the number of sales reps we have based on the length of time they've been selling for us.  I have a ramping schedule similar to the simple...
joeort's avatar
joeort
Icon for Advocate IV rankAdvocate IV
10 years ago

Thanks, Itchy.  The Attendance table is the part I'm struggling with.  Any ideas on how to build that when all I have to start is the rep and the dates?

itchyeyeballs's avatar
itchyeyeballs
Icon for Impactful Individual rankImpactful Individual
10 years ago

If its feasible for you then I think a stored procedure in your database may be neatest way to go.

 

A quick and dirty alternative would be to manually create a template table in excel prepopulated with data for all the months and reps you will need for past and future (100 months and 100 reps for example). Import it into the model and calulate the score column on the fly using your start and end dates. The template would just act as a framework to hang your real data (start/end dates) from.

 

If you link your newly created table to your reps table you can restrict results to just matched reps, all the other data would be ignored until a new rep was added that matched.