CiviCRM Stack Exchange is a question and answer site for administrators and users of the CiviCRM Constituent Relationship Management software. It only takes a minute to sign up.
Sign up to join this community
I have done a CiviCRM installation for a local networking club. They are adopting CiviCRM slowly, and at the moment we only have the member's contact records and membership records imported.
We need a report that shows the number of memberships that are of different statuses; they want to know at any given time how many current members, grace members, expired members, etc.
How to do this?
If you are wanting a 'count' for each status, ie a small table showing eg Member Type X, Status A 12 Member Type Y, Status A 5 Member Type X, Status B 15 etc
and if you are using Drupal, then I built a View to demo how you can do this which you can download from here
NOTE: you may need log in as user/1 (or Masquerade as admin) in order to access the Import View window.
NOTE: this was done in response to the stackexchange question
By "any given time", do you mean you want to be able to pick any historical date and see how many members you had in each given status? If so, that's not doable out of the box. You can get basic total member numbers by searching on start/end dates, but this won't catch people in 'New' or 'Grace' periods etc.
Afaik most CRMs struggle with this idea of looking at data from a particular point in time. It's a regular question I get, and tbh I never have a good answer. For what it's worth we just use an script which dumps member numbers to a csv once a day.
Steps are:
That's it
