2 Replies Latest reply on Jun 9, 2016 5:38 AM by Carlos Edo

    Orders per Buyer (Count Distinct in Running Period)

    Carlos Edo

      I'm trying to calculate the Running ratio of Orders per Buyer.

       

      The calculated field that I'm using right now is:

       

      [Number of Purchases] / COUNTD([Paying customers by User.id])

       

      This works fine for a Total or for each month. But what I need is to calculate the Running Sum.

      The problem here is that it first calculates the COUNTD and then does the Sum.

       

      Is there any way to force it to do it the other way?

       

      Thanks for your help.

      Carlos