5 Replies Latest reply on Aug 5, 2015 6:05 AM by Ian Burdin

    Average order value calc field

    Ian Burdin

      Hi all


      I have some basic campaign data which is all fine, apart from the calculated fields I have created.


      The data has orders, revenue, visits and quotes. I have created 4 fields:


      Average Order Value (Revenue/Orders)

      Conversion (Orders/Visits)

      Quotes to visits (quotes/visits)


      I want to split these metrics out by channel (social media, display, aggregator etc) and by device type (desktop, tablet etc)


      The data has integrated into Tableau fine, but when I introduce a channel and device type split, the calculations are incorrect.


      For example using a simple calc in excel...for the aggregator channel the numbers are:


      Orders: 14,689

      Revenue: £2,753,250


      AOV should equal £187.43 but as per the attached workbook, the answer I'm receiving is £179.11


      Similarly, conversion should equal 27.8% but in the workbook the answer is 28.9%.


      Any help gratefully appreciated!