Open Rate/Click Rate

  • 21 July 2022
  • 0 replies

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.

0 replies

Be the first to reply!