Open this example document containing dummy data
Watch this video of the calculation process:
https://www.loom.com/share/585778eb2e8b46efb4363adfcf04ae69
Open a new google sheet/excel file
Log into myturn with admin account
Go to Members > Search/Export
Choose a time period. Select the date you want to start on - Created on or after - and the date you want to end - Created on or before. Include deactivated accounts so you still count members who have since left.
Export the csv file and save it on your computer. Open it in google sheets/excel
Delete all personal information! You don't need name, address, phone etc.
You want to total all members for each month, so add a column for Month and Year. Add the months and years in your data, eg: Jan2020, Feb2020, Mar2020
Create a column that shows the month the member signed up, using "=MONTH(B2)"
Create a column that shows the month the member signed up, using "=YEAR(B2)"
Create a column for each type of membership in Current Membership Type, making sure to use the exact spelling (copy and paste)
Use this formula to count all the members that signed up in 2020, February, that have a "Standard Membership". =COUNTIFS($J1:$J599,"2020",$I1:$I599,"2", $D1:$D599, P1)
Copy and paste this formula into every cell, making sure to change the column heading reference as needed
Create chart by highlighting everything, clicking Insert > Chart and selecting line chart