1 of 1 people found this helpful
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!
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
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!
Thanks again for your help.