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?