This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

A simple SUMIF...that I can't figure out. How do I do this?

Posted on 04-16-2024 02:45 PM
Kev77
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

Hi everyone. I have a simple problem that I can't figure out in Looker. I am trying to replicate the Excel formula below in green. What is currently happening in Looker is the formula in red. More info below...

I want to showcase an email Unsubscribe Rate. The formula for the Unsubscribe Rate is simply the sum of all unsubscribes divided by the sum of all emails delivered. HOWEVER - there are a few instances in my dataset where our tool's unsubscribe functionality wasn't working therefore there are blanks. I want to ignore these instances so that my unsubscribe rate is accurate. Currently, it is including instances where we have no unsubscribe data. This makes the unsubscribe rate appear lower than it actually is.

Lookerstudio sumif question.PNG

Any thoughts on how I can accomplish this? THANK YOU!!!

0 6 189
Topic Labels
0 Likes
6 REPLIES 6
Top Labels in this Space