3 Replies Latest reply on Apr 3, 2018 12:50 PM by Deepak Rai

    Tableau 10.3: Running Sum  works for 1st Associate but not for rest of them

    Bradley Smith

      I am trying to determine if Action is Needed based on the number of new of occurrences for each Associate.

       

      Basically,

       

      if RUNNING_SUM([New Occurrences ]) >= 3 THEN 'Y'

      else 'N'

      END

       

      However, it works for when the Running Sum first reaches 3 and sets everything else following it to 'Y' as well regardless if the Running Sum for that Associate is 3 or not.

       

      Any ideas?

       

      Best Regards,

      Brad Smith