4 Replies Latest reply on Jan 14, 2019 11:09 PM by Selvam Periyasamy

    Funnel chart using 4 values calculated from 4 different formulas

    Selvam Periyasamy



      I need to create a funnel chart like below,



      I have four values calculated from four different forumlas like below,


      Impressions = { FIXED [CustomerID],[CouponCode],[Campaign Name],[Campaign Id],[Campaign Template Id],[Sent Date],[Retailer Code]:COUNTD([CustomerID])}

      CustomersTargeted= COUNTD([CustomerID])

      Responders = COUNTD(IF [Responder]=1 then [CustomerID] END)

      ActualResponders = COUNTD(IF [ActualResponder]=1 then [CustomerID] END)


      Can someone please let me know how to do it?


      The online help has not been that useful