Open Rate/Click Rate

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 0 100
0 REPLIES 0
Top Labels in this Space
Top Solution Authors