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.