Topics started by ksears
I am trying to calculate the open rate/click rate from a field called “actions”. Within the field “actions” I have “open”, “click”, “delivered”, etc. I can create a pivot table by date to show me the count of these three actions. I need to divide the count of each action by the delivered count. I can calculate this in SQL, but I can’t figure out how to do this in Looker; Is there a way to do it as a table calculation or should I be using LookML? I’m new to writing in LookML.
Already have an account? Login
Login to the community
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.