Conversion Rate

Hello!

I am attempting to create a look that will show me a conversion rate by dividing the number of newly created customers with 0 orders by the number of newly created customers with >1 orders in a given time frame. I have defined “not converted” as 0 and “converted” 1 by using:

case(when
(${order_count_sum}>0
,1),
0)

That said, I am quite new to Looker and am struggling to write a custom expression that will generate a percentage (i.e., count all of the 0’s and divide it by the count of 1’s).

Does anyone have any suggestions for how to create this either as a separate expression, or as part of my initial expression?

0 0 119
0 REPLIES 0
Top Labels in this Space
Top Solution Authors