I am getting similar LTV and AOV. That is $410 for 2019 and $465 for 2020. AOV= SUM([Total order value])/COUNTD([Consumer ID])

Hi Abrar, thanks for reaching out! It seems that for calculating the average order value you're dividing by the number of unique users, instead of the unique orders. That's why your result is similar to the LTV value. To adjust it, you need to divide by the number of Order IDs, instead of the consumers and that's how you'll get the average order value. If anything else comes up, please let us know in the Q & A. Best, 365 Eli

Follow this topic

Abrar Muhtasim

Last answered:

11 Oct 2022

Posted on:

07 Oct 2022

Resolved: Getting same LTV and AOV

in Fashion Analytics with Tableau / Introduction to the Case Study

1 answers ( 1 marked as helpful)

Elitsa Kaloyanova

Instructor

Posted on:

11 Oct 2022

Helpful answer

Resolved: Getting same LTV and AOV

Submit an answer

related questions