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

# Filtering customers on Avg order value

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_id first_name last_name order_count phone email

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

• ###### 1. Re: Filtering customers on Avg order value

Hi Travis,

Every Rookie can "flip" a business model nowadays. So go for it;)

Find my approach based on LOD expressions explained here. and stored in workbook at Tableau Public here

a. calculate the average per Customer.

b. Figure out if AOV meets exact Ordervalue of one order of a Customer

c. Define filter to select only the orders which are exact the AOV per Customer

Hope it helps...

3 of 3 people found this helpful
• ###### 2. Re: Filtering customers on Avg order value

Thank you! This is really helpful. Let me plug this in and play around with it. At first pass this looks like what I need!

• ###### 3. Re: Filtering customers on Avg order value

Hi Travis,

Glad I could help. Thanks for the awards. Much appreciated.