Question

Conversion Rate

  • 31 December 2021
  • 0 replies
  • 11 views

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 replies

Be the first to reply!

Reply