3 Replies Latest reply on Feb 29, 2016 5:05 AM by Tharashasank Davuluru

    How to do data blending with two additional datasources

    Niels Bosma

      Hi community,


      I'm trying to visualize how many of my users that also make a purchase (aka a commitment) in the same session as they registered and I'm trying to use data blending to do this.


      My datasource looks like this:


      Inline image 1


      Registrations has ConversionTypeId=1 and Purcahses 2.


      In my main datasource I set a filter for ConversionTypeId=1 and then I duplicate the datasource and change the filter for this one to  ConversionTypeId=2  and link on SessionMatchingId.


      This turns out great:


      Inline image 2


      But I want to compare "T0 commitments" with all the commitments. So I duplicated the datasource again and this time linked on Timestamp.


      Inline image 3


      The number for the third get completely weird? (Total should be around 1800 commitments).


      I've tried with COUNTD(ConversionId) but that was unsupported


      Calculated fields are just a SUM([Number of records]).


      Thanks for you help.