2 Replies Latest reply on Sep 27, 2018 1:12 PM by Rick Ransome

    Need help showing a conversion rate with data not in data source

    Rick Ransome

      Hi community.

       

      I need help to show a conversion rate with data not in the data source.  In summary, I would like to take a unique count of values in a "column A" filter for select values in "column B" then divide by a fixed number to show a %.  Something like:

       

      If  column A = 'xx/yy' then countd and divide that total by 1,234 and if column B = 'yy/zz' then countd and then divide divide that total by 2,321, and if column C = 'aa/bb' then countd and then divide divide that total by 3,233. 

       

      Is this possible?  Please help! :-)