5 Replies Latest reply on Apr 18, 2018 12:11 PM by Deepak Rai

    Count of events per user

    lekesha.lewis

      Hey there, I have a chart which is essentially USER | MM first MQL Date | Activity Date. The activity dates vary in quantity per user and I need to be able to generate a column which takes a count of them per user and returns a Y/N value based on that count (preferably within a window relative to the MQL date). 

       

      I used:

       

       

      IF(COUNTD([Activity Date]) > 5) THEN 'Y' ELSEIF COUNTD([Activity Date]) < 5 THEN 'N' END

       

      Which returns a column of N's because of course it reads each date as "1." I'm sure there's a relatively simple fix I'm overlooking but if anyone has any guidance so I'm not trial/error-ing this all day, that would be great.