4 Replies Latest reply on May 31, 2016 11:06 AM by Joe Oppelt

    Combine multiple dimensions into one

    nick.cook.0

      I have a dataset that of prospects that we will be marketing to through different channels. Each prospect is labeled with the channel that will hit them like below:

      ProspectDirect MailEmailOutbound Call
      1YY
      2Y
      3YY
      4

      Y

       

      I want to combine the three channel fields into one dimension so the output looks like:

      ChannelCounts
      Direct Mail2
      Email3
      Outbound Call1

       

      And then show the % of Total:

      ChannelCounts% of Total
      Direct Mail250%
      Email375%
      Outbound Call125%