Re: Formula field that calculates average values based on same date and same name of agent
Thank you for this.
Sorry, just to make it clear, I actually need to look at the "Effective Date Calculated" field which we enter data manually into. So, we have records with Effective Date Calculated that looks on a weekly basis like on 9/23/19, 9/30/19, 10/07/19 and so on. I need to look at the ones with same Effective Date Calculated then get the average of Daily Quality Score per Agent and show on the Weekly Quality Score column where in the example I showed with 09/30/19 as Effective Date Calculated then with scores ([(94.44 + 100)/2]=97.22), it should show 97.22. I will do the same thing for Daily Attendance by looking at same Effective Date Calculated then get the average of Daily Attendance per Agent and show on the Weekly Attendance column. Hope that makes sense.
In this case, do I need to follow steps 3 and 5 from what you sent? I tried importing data to the table I created called Weeks (step 1) with fields (Project Name, Effective Date Calculated, ID, Daily Quality Score, Daily Attendance) similar to the way we import to Badge table but it needs the merge field Week Start. Am I missing something? Again, I manually import data that's only based on the start of week 9/23/19, 9/30/19, 10/07/19...
------------------------------
Ma. Isabel Gumanid
------------------------------
Sorry, just to make it clear, I actually need to look at the "Effective Date Calculated" field which we enter data manually into. So, we have records with Effective Date Calculated that looks on a weekly basis like on 9/23/19, 9/30/19, 10/07/19 and so on. I need to look at the ones with same Effective Date Calculated then get the average of Daily Quality Score per Agent and show on the Weekly Quality Score column where in the example I showed with 09/30/19 as Effective Date Calculated then with scores ([(94.44 + 100)/2]=97.22), it should show 97.22. I will do the same thing for Daily Attendance by looking at same Effective Date Calculated then get the average of Daily Attendance per Agent and show on the Weekly Attendance column. Hope that makes sense.
In this case, do I need to follow steps 3 and 5 from what you sent? I tried importing data to the table I created called Weeks (step 1) with fields (Project Name, Effective Date Calculated, ID, Daily Quality Score, Daily Attendance) similar to the way we import to Badge table but it needs the merge field Week Start. Am I missing something? Again, I manually import data that's only based on the start of week 9/23/19, 9/30/19, 10/07/19...
------------------------------
Ma. Isabel Gumanid
------------------------------
