9 Replies Latest reply on Mar 14, 2018 2:04 PM by Deepak Rai

    Average Multiple Samples into weighting of 1 sample per user

    Bob Lindas

      Hi all,

       

      Long time reader. Was wondering if someone could help me with this. I have a dataset that has users that generate samples in a given day, and what I'd like to do is take all the samples of that unique user, average them, and treat them as 1 sample, for the time period specified. I would do that for multiple users, so in the end, regardless of how many tests a user performed, that particular user would have an average sample rating of 1, for the defined time (day, week, month, year, etc).

       

      For example,

        

      DateUser 1User 2User 3
      01-Jan878
      02-Jan415096
      03-Jan99
      04-Jan841538
      05-Jan63
      06-Jan9686
      07-Jan5554

       

      Average Per Week

         

      Average Per Week User 1Average Per Week User 2Average Per Week User 3Required Total Weekly Average (all unique user samples treated as 1 sample) (73.66+52.166+65.8)/3
      73.6666666752.1666666765.863.87777778

       

      Is this possible?