Hello, I would like to create field in the script that shows how long the Sales Rep has been active. I'd like to be able to pull it in as a filter called Tenure that has options in increments of half years 0.5, 1, 1.5 etc. Allowing an individual to select sales reps that have been active for a certain amount of time easily.
Is there a way to calculate a number for each sales rep that takes todays date less the date of their first appointment and round it to the half year?
My script has the following data in it that I believe would be necessary.
Thanks Andrew! I am still missing something I am assuming is really easy. I keep getting an invalid path error when I put this in. Any idea what could cause that? I have that EnabledDB_Reporting source in multiple locations in my script already.
CLASS(FLOOR(TODAY() - FirstAppointmentDate)/365,0.5) AS DaysSinceFirstAppointmentGroups;