I have a workbook with month and year on the X axis (INTERACTION.DATE), and a ranking score on the Y axis(NPS.SCORE), to represent the story of how a shop's associates performed over time. In the graph itself, I have a couple thousand lines representing the associates themselves, and how they performed over time.
My question is: how can I take the "average" of all the points, based on the month and year, to give the average sales associate score over time? I've tried the running average and window average but couldn't get them to work (not sure if doing wrong.)
Unfortunately, cannot post workbook for job privacy reasons