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

      Hi,

       

      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