1 Reply Latest reply on Feb 26, 2013 7:23 PM by Joshua Milligan

    How can I count distinct customer IDs by month, and then find an average in a calculated field?




      This might be a silly question but I'm having a hard time doing this.


      I have a monthly record of orders by customer ID. So a customer may place multiple orders in a month, or none at all.

      I want to calculate a monthly average of DISTINCT customers in a month.


      E.g. Month 1 may have 100 customers (who place a total of ~200 orders)

      Month 2 may have 100 (50 old and 50 new)

      So the average should be 100.


      Right now I can get a distinct count across the entire dataset but no way to average in a calculated field.