4 Replies Latest reply: Nov 28, 2017 4:55 AM by Max Beer RSS

    Comparing with a constant value

    Max Beer

      Hi there,

       

      I am trying to figure out how many users have been active in a certain period of time. I can use this to find out the amount of days since their last login:

       

      ceil(Interval(Today()-date([users.last_login], 'DD.MM.YYYY'), 'D'), 1)

       

      But comparing it to a constant (in this case 30, for 30 days) does not yield any results:

       

      count({< {30} = {'>=$(=ceil(Interval(Today()-date([users.last_login], 'DD.MM.YYYY'), 'D'), 1))'}>} DISTINCT users.id)

       

      Any suggestions on what I'm doing wrong?

       

      Thanks