This content has been marked as final. Show 1 reply
It's a rather easy question but I'm still learning tableau. I created a new calculated field in tableau for effectiveness % which is simply sum([received]) / sum([sent]). There is also a filter on the dashboard which only shows a single day that the user can choose. I wanted to compare effectiveness % from any day selected with its previous day.
ex: 11-Jun has effectiveness % of 85%. 10-Jun has effectiveness % of 80%. The difference is +5%. How do I write this formula to get 5%? I was going to get this value and assign it a green arrow if it's positive, red if not, etc (I know how to do that step)
My excel table is set up as followed: