1 Reply Latest reply on Feb 13, 2017 5:11 AM by Norbert Maijoor

    Average over time for multiple lines

    Jessie Yen

      Hi all,

       

      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

       

      Thank you so much for your help!