This content has been marked as final. Show 2 replies
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.