Looker Connect Training
Help Center
Documentation
Community
Cloud Certifications
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?
Hello! I am attempting to build a look showing average client lifespan. The applicable dimensions are client_tier_5.admission_date_dateandclient_tier_5.discharge_date_dateIt’s been fairly straightforward to create a calculation to count diff_days between either the admission date and now() or admission date and discharge date, but I’m struggling to bridge the gap and create one calculation that can count diff_days between admission date and now (if discharge date is null) AND admission date and discharge date (if discharge date is not null). What is the best approach to accomplish this? I’m still learning SQL, so any help would be appreciated. Thanks!!
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
