I am trying to find the conversion % for two different marketing sources. What % of those that inquire in either the walk in channel or the phone channel actually rented.
I wrote this beast mode calculation, but nothing is displaying:
SUM(CASE WHEN 'lead_source' = 'Walk_In' AND 'unit_rented_c' = 1 THEN 1 END)/SUM(CASE WHEN 'lead_source' = 'Walk_In' THEN 1 END)
Looking at the calculation beast mode isn't giving me a syntax error and the logic seems to make complete sense. What am I not accounting for?