3 Replies Latest reply on Jul 7, 2016 6:01 PM by lei.chen.0

    Get difference from last value of each month

    Nick Osdale-Popa

      I'm capturing Job-To-Date data on a weekly basis and I want to compare the last EMAC % of each month to show the difference.

      I was able to filter the data to show the last EMAC% per month, but my calculation for the difference isn't working out.

      I've attached the Tableau Workbook with tabs of my progression and where I'm stuck. Hopefully it explains what I'm trying to do a bit better.

      Basically, I want to turn this:

       

      raw.PNG

      Into this:

      output.PNG

       

       

      Any insight into what I'm doing wrong would be appreciated.