2 Replies Latest reply on Sep 12, 2012 10:21 AM by Wilson Po

    Newbie question: Average customer sales by month?

    Zach Buckner

      I have sales data stored in a table with three fields: UserId, DatePurchased, and AmountPurchased.  I'd like to generate a report that shows average total spending per user, per month. Note that I don't want the individual users enumerated as separate rows or columns, just a simple report to convey: "the average user spent $X in July; the average user spent $Y in August."

       

      I've learned how to use the aggregation feature to get average transaction value per month but our users typically have multiple purchases per month, and I'd like average cumulative purchases for the month.  Any help on this would be greatly appreciated.