4 Replies Latest reply on Apr 18, 2018 10:10 PM by lekesha.lewis

    Return value based on items count in window

    lekesha.lewis

      I have an aggregate "Y/N SLA" designed to return a Y/N value if a certain number of activities occurs per user:

       

      MAX( IF( {FIXED [Contact Name]:COUNTD([Activity Date])}>=5) THEN "Y" ELSE "N" END)

       

      How would I go about modifying it to return Y/N based on a count of only those Activity dates within 30 days of the MM First MQL Date? I've been toying with DATEDIFF and WINDOW_COUNT but they're returning results I'm not quite looking for. Removing the dates outside of that window doesn't impact the Y/N value or the activity count.

       

      Thanks!

       

      vs 10.5, dummy file attached