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


      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


      Is this possible?