3 Replies Latest reply on Nov 14, 2016 11:07 PM by Norbert Maijoor

    Filtering customers on Avg order value

    Travis Hall

      Rookie here. I am trying to "Tag" Customers that have an Average Order Value (AOV) of $20 over multiple orders. So a customer could order $10 on order then $30 the next and then $20 for the next 5 orders and they would be a "$20" AOV customer. Here is how my tables are formatted.

      AOV is calculated:
      SUM([Subtotal])/COUNTD([Order Id])

      Table 1 

      Order_Id, user_id, ordered_at, subtotal

       

      Table 2

      user_idfirst_namelast_nameorder_countphoneemail

      Screen Shot 2016-10-07 at 4.24.45 PM.png

       

       

       

      How can I tag these people in my reports? and how could I tag orders that are just $20 AOV?