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?