I would like to create a monthly trend chart of users who return to perform a particular event. However, I only want users to count as "returning" if they had performed that event at some point in the 3 months prior to the return event.
So let's say user A performs my event on September 13 and comes back to perform it again on October 20th, I would like them to count in October as a returning user. If User B performed this event in May and then came back in October, I would not want them to count because that is outside of the 3 month window (prior to October). If User C performed my event on October 13th and came back on October 20th, I would also want them to count in the October returning user count (though I am flexible on this one if this makes it harder).
Is there any way to build a chart like this using formulas or cohort building?
