1 Reply Latest reply on Sep 1, 2016 11:29 PM by Sankarmagesh Rajan

    Previous month calculation help needed

    Mikey Michaels

      Hello All,

      First, thank you for your time!

      I have been struggling with creating a previous month calculation for a little while and thought I should pose to the Tableau Forum before I lose my mind!

      On the attached, I have calculated the RC Utilization percentage for the Current Month (based off my parameter, "Curren Month"). This percentage is calculated by taking the Reason Codes that do not = "#" / Total Reason Codes....this was pretty simple to create.

      However, when I tried to calculate what the utilization would be for the previous month (June 2016 in this example) I'm really struggling. I thought I could add something like the following:

       

      IF

      ATTR(DATEDIFF('month',[Month],[Current Month]))=1

      THEN .....

       

      However, that doesn't work. Any ideas on how to fix?

       

      Thanks for your time!

       

      Cheers,

      Mikey