Author Topic: Find active memberships in a date in the past (Read 660 times)

xavier · February 10, 2011, 12:51:49 am

Hi,

Wanted to see how many members I had end of last year. All the reports I saw where about the date when they joint.

Is there a way to get the same dashboard view (or any view actually) to see how many active members I had at a specific date ?

(badly need it for reporting)

X+

Dave Greenberg · February 14, 2011, 01:49:13 pm

I don't think there's an existing report or search that can give you that data. You MAY be able to reconstruct the active membership count at a given time using these steps:

* Get count of current active memberships
* Query civicrm_membership_log for all entries between now() and the past date. Group and count by status_id. Then subtract log counts for any NEW statuses (since they were inserted after past date), and add counts for EXPIRED statuses. I think this gets you pretty close.

Going forward, printing off / saving PDF of monthly or quarterly report is a good idea if you need to track this (unless you find the above calc's easy enough to turn into a custom search or new report).

CiviCRM Community Forums (archive)

News:

Author Topic: Find active memberships in a date in the past (Read 660 times)

xavier

Find active memberships in a date in the past

Dave Greenberg

Re: Find active memberships in a date in the past