1 Reply Latest reply on Jun 30, 2018 4:17 AM by Jim Dehner

    How do I compare values from the same column for different days

    Chad Clauson

      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:

      Date
      Received
      Sent
      7-Jun90100
      8-Jun100100
      9-Jun95100
      10-Jun80100
      11-Jun85100