This content has been marked as final.
Show 5 replies


2. Re: Average order value calc field
Sankarmagesh Rajan Aug 5, 2015 5:46 AM (in response to Ian Burdin)1 of 1 people found this helpfulHi Ian,
change AOV calc as sum(revenue)/sum(orders)
drag this into measure area. now get 187.43
thanks
sankar

3. Re: Average order value calc field
Ian Burdin Aug 5, 2015 5:48 AM (in response to pooja.gandhi)Brilliant many thanks

4. Re: Average order value calc field
Konrad Keck Aug 5, 2015 6:03 AM (in response to Ian Burdin)Hi Ian,
that's a logical issue here. Your formular tells tableau to make 'x' / 'y' and then take 'AVG' of the results. But what you want, is the weighted average. That will be the 'SUM of x' / 'SUM of y'.
Looks like that:
Done. The result will already be the weighted average:
I put that in your *.twbxfile and attached it.
Does that help you?

campaign data  KK.twbx 54.8 KB


5. Re: Average order value calc field
Ian Burdin Aug 5, 2015 6:05 AM (in response to Konrad Keck)many thanks