2 Replies Latest reply on Jun 9, 2016 4:46 AM by Carlos Edo

    Organizers still active after 1 year

    Carlos Edo

      Hi all!

       

      I need to calculate the number of event organizers that are active after 1 year. Active meaning that they created an event in the last 6 months.

       

      I want this to be calculated month by month so, for example, in my view, under May-2016, I would see the number of users that created their first event one year ago (May-2015) and created at least one event in the last 6 months (after November-2015).

       

      So far I got this calculation:

       

      IF [Last Event] > DATEADD('month', -6, TODAY()) THEN [Id] END

       

      But that has two problems.

      First, I don't know how to access the running date for each month instead of TODAY, so the calculation is done relative to Today instead of changing for each month.

      Second, I don't know how to shift the data for one year. Now, the data shown under May-2016 is that of the users that created their first event on that same date, instead of on May-2015.

       

      Thanks for your help.