3 Replies Latest reply on Dec 20, 2016 2:18 PM by Shinichiro Murakami

    Average of a sum across sets

    Christopher Demundo

      Workbook attached.


      I'm breaking up my data by how many product lines a customer has purchased. 


      I want to know, for each grouping, say of "customers that have purchased 5 products", what their total average sales is per customer.  So answering the question, do customers that have purchased 5 products have higher average sales than customers that purchase only 1 product?  


      I would think "WINDOW_AVG(SUM(sales_amount))"  calculated across "how many products used" would work, but it is not.