3 Replies Latest reply on Feb 6, 2019 8:04 AM by Hannah Williams

    Create an average on a distinct value

    Hannah Williams

      Good Morning

       

      This is my data set, you will notice that some id's (rows) are duplicated. I can not avoid these duplicate rows. But I want to avg the total list based on distinct id's. How can I do this in a calc?

       

        

      44BCD8BC7D6145DA6E6177B265BABAFF:RWSRHGXPNEFGEIABX17.744
      44BCD8BC7D6145DA6E6177B265BABAFF:RWSRHGXPNEFGEIABX17.744
      8C2817B5A9ACC0928B1741F0891605B1:GSEVTTZURSHPDUKUW5.864
      383D56B4FDC7A58B8CBBFC002F6F0664:PDQSLFZIDVZHZHBVJ8.926
      081D17FC58E246AAEF6737497D573356:KDOIYYXDXVAFBOGTX8.398
      081D17FC58E246AAEF6737497D573356:KDOIYYXDXVAFBOGTX8.398
      60C15A47D0FFAF6F38A23047E86D9E28:CQAUMSYHLQFVECTFC10.654
      49C90F8D8AD5E6F0DF2D2F53CCF51C0B:JJIJZYVCCYNWJDKZF6.137
      A8EE522540EC85122C5D75224093BC3B:WKSNYPUMAAZXAWHKQ8.417
      348130CB0F79ABE3C4F19F62FC95B626:VDLQSGYJNTBRZOIOP12.969
      348130CB0F79ABE3C4F19F62FC95B626:VDLQSGYJNTBRZOIOP12.969
      348130CB0F79ABE3C4F19F62FC95B626:VDLQSGYJNTBRZOIOP12.969
      348130CB0F79ABE3C4F19F62FC95B626:VDLQSGYJNTBRZOIOP12.969
      B4454360672B3C057EF2A7FA2CB024D9:ZRUFLBTQNLUCOYTUD5.646
      7CF687FB59387F59CB41EF97DC105CB2:KNGFDTSHWXNPTDXOC7.776
      AVG10.50533

       

      Distnct list

      44BCD8BC7D6145DA6E6177B265BABAFF:RWSRHGXPNEFGEIABX17.744
      8C2817B5A9ACC0928B1741F0891605B1:GSEVTTZURSHPDUKUW5.864
      383D56B4FDC7A58B8CBBFC002F6F0664:PDQSLFZIDVZHZHBVJ8.926
      081D17FC58E246AAEF6737497D573356:KDOIYYXDXVAFBOGTX8.398
      60C15A47D0FFAF6F38A23047E86D9E28:CQAUMSYHLQFVECTFC10.654
      49C90F8D8AD5E6F0DF2D2F53CCF51C0B:JJIJZYVCCYNWJDKZF6.137
      A8EE522540EC85122C5D75224093BC3B:WKSNYPUMAAZXAWHKQ8.417
      348130CB0F79ABE3C4F19F62FC95B626:VDLQSGYJNTBRZOIOP12.969
      B4454360672B3C057EF2A7FA2CB024D9:ZRUFLBTQNLUCOYTUD5.646
      7CF687FB59387F59CB41EF97DC105CB2:KNGFDTSHWXNPTDXOC7.776
      AVG9.2531