New Members Month Over Month Help
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Good Afternoon,
I am trying to design a workflow that would use historic data to determine new membership month to month. Each member is assigned a unique Member_ID when they join.Each month we receive a report that contains all membership (new and Old). Since I don't have an identifier for a new member what is the best way to determine who the new members are?
~Dylon
Solved! Go to Solution.
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
So to confirm, there isn't currently a "Joined Date" or something similar in your data? If there was, you could just pull the month out of that date and use it to summarize the number of people for that given month.
Otherwise, you will want to use the join tool of your new data set back to your old data set. The L or the R depending on which way you have it set up, will show the members that exist in the new data set but not in the old and would therefore be new members.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
No there isn't a Joined date, however the use of the Join will do it!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @connerdy ,
Is there any reference point to identify its new or old member, or how you are defining it right now which member is old/new
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
As mentioned in my description we currently don't have a flag for if the member is new or not. The only thing I have is a unique ID that is assigned to the member once they join. I do have a payment_date field that tells me which report I'm looking at in the table.