Answers.Body: <p>There are at least two ways of calculating historical membership numbers:</p>
  <ol>
  <li>The membership dashboard uses the activities that are generated when a membership is created/renewed/expired.</li>
  <li>The membership churn chart extension uses some sql based on just the membership records.</li>
  </ol>
  <p>In the real world, neither of those are always the whole story, it depends on how you manage your memberships (e.g. restarted expired memberships, etc.)</p>
  <p>I'd start with the churn chart extension, and take a look at the sql if the numbers look like what you want.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-10-03T17:17:04.690Z
Answers.LastActivityDate: 2023-10-03T17:17:04.690Z
Answers.UserDisplayName: Alan Dixon
Body: <p>We are using CiviCrm 5.65.1.</p>
  <p>We would like to extract historical membership counts for certain time periods in the past say CAlendat  Year 2014, 2015 etc.</p>
  <p>The typical membership status that we have are New, Current, Grace, Expired, Pending Cancelled, Deceased and Resigned.</p>
  <p>New members join and have differing membership expiration dates.
  One complication is that we have a membership category of &quot;Life&quot; with a membership expiration date of 2100 and in some cases blank.</p>
  <p>Question - what would be the easiest way to obtain this count on a historical calendar basis.</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-10-04T05:31:55.007Z
Comments.Text: @ Alan Dixon...many thanks I will have a look at this extension when I upgrade to 5.66 next week.
Comments.UserDisplayName: markd
Tags: <wordpress><civireport><reports><searchkit>
Title: Historical Membership Count reports based on Calendar Year
ThreadText: # Historical Membership Count reports based on Calendar Year
  
  (Asked by: username_0 on 2023-10-02)
  
  We are using CiviCrm 5.65.1.
  
  We would like to extract historical membership counts for certain time periods in the past say CAlendat Year 2014, 2015 etc.
  
  The typical membership status that we have are New, Current, Grace, Expired, Pending Cancelled, Deceased and Resigned.
  
  New members join and have differing membership expiration dates.
  One complication is that we have a membership category of "Life" with a membership expiration date of 2100 and in some cases blank.
  
  Question - what would be the easiest way to obtain this count on a historical calendar basis.
  
  **Tags:** wordpress, civireport, reports, searchkit
  
  > **Comments:**
  > **username_0**: @ username_1...many thanks I will have a look at this extension when I upgrade to 5.66 next week.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2023-10-03. Score: 1
  
  There are at least two ways of calculating historical membership numbers:
  
  1. The membership dashboard uses the activities that are generated when a membership is created/renewed/expired.
  2. The membership churn chart extension uses some sql based on just the membership records.
  
  In the real world, neither of those are always the whole story, it depends on how you manage your memberships (e.g. restarted expired memberships, etc.)
  
  I'd start with the churn chart extension, and take a look at the sql if the numbers look like what you want.
  
  
  ---
  
  