5 Replies Latest reply on Oct 12, 2016 12:59 PM by Lisa Li

# How do I easily calculate Open Rate in Tableau?

Hello,

I'm trying to calculate the open rate of two columns in one of my sheets. Opens/Delivered. I've tried numerous calculations and created several field calculations, but the number is still incorrect...

In this screenshot the campaigns are subtotaled. Can anyone help?

It appears that the error is happening in measures. It appears to reSUM everything, even though all campaigns are already totaled/Summed.

Thanks

• ###### 1. Re: How do I easily calculate Open Rate in Tableau?

Hey Ashley,

If I'm understanding you correctly, you can show Delivered and Opens as min([Delivered]) instead of sum([Delivered]). And also calculate Opens/Delivered with min([Opens])/min([Delivered])

This is just to return the already subtotaled Opens and Delivered amount instead of summing it again, which is what tableau wants to do because of the way it's organized.

Hope this works!

Lisa

1 of 1 people found this helpful
• ###### 2. Re: How do I easily calculate Open Rate in Tableau?

Hi Lisa,

This was very helpful! But, the calculation still appears to be slightly off. I used your min([Opens])/min([Delivered]) as recommended above. And here's what I got:

The answer for the first Abandon Cart email should actually be 55.83%. Any other thoughts?

Thanks!

• ###### 3. Re: How do I easily calculate Open Rate in Tableau?

Hmm. My first instinct is to try SUM([Delivered])/SUM([U Opens]) --> exactly what is shown on the table instead of min([U Opens])/min([Delivered]).

Might be silly and futile but I guess we'll see

-Lisa

• ###### 4. Re: How do I easily calculate Open Rate in Tableau?

So, your original formula was in fact correct, where it's SUM([U Opens]/SUM([Delivered]).

I think the issue was where I was pulling the data from. Here's what I did and it worked.

1. I created a calculated field

2. Pulled the above calculation from the Measures Values SUM([U Opens]/SUM([Delivered]) (NOT the Measures area, which I might have been doing before) - Saved

3. I then pulled this new value into columns and changed the format to percentage and it worked!