9 Replies Latest reply: Feb 12, 2014 9:18 AM by Nicole Smith RSS

    Find price in same session

      Hi,

       

      I have a problem - See attached for example:

       

      Basic thing:

       

      I need the Price when there is an eventtype called Buy, but they also have an eventtype called Itemclick - They should be within same session.

       

      As it is now it shows me the price for a visit - I dont want that - It should only be on the buys.

       

      Example

       

      RowID, CreateDate,EventType,Price, sessionid

      1, 2014-02-02, itemclick, 0, 12121

      2,2014-02-02,visit,203,12121

      3,2014-02-02,buy,205,12121

      4,2014-02-02,buy,202,12121

       

      Then my price should be seen on both and total should be 407.