I have a membership-based program where people sign up and their subscription lasts for 365 days.
I am trying to develop a crystal report that shows how many people are signed up at a given time e.g. each day (or instead of each day, I might choose the first day of each month as my date to reference to keep the number of data points fewer.).
There is a date field in the database that signifies the start date of the membership.
I can easily generate a report showing how many people are signed up at a particular date, and a report showing how many people have signed up during a time period, but I'm looking for a way to graph the # of currently enrolled over four years.
I thought it would be easy, but I'm having trouble with the logic or something here. I thought I'd be inserting groups for each day and then counting the subscriptions that fall between that day and 365 days before that day, but I'm having problems.
9/17/12: 1,209 enrolled (includes those enrolling between 9/17/11 and 9/17/12)
9/14/12: 1,235 enrolled (includes those enrolling between 9/14/12 and 9/14/11)
9/13/12: 1,2330 enrolled "" "" 9/13/12 and 9/13/11
4/20/10: 725 enrolled (4/20/10-4/20/09)
9/17/08: 112 enrolled (start date of the program was 8/20/08)
8/21/08: 15 enrolled
8/20/08: 0 enrolled
I need help.