Line Chart not showing second line of data - Survey Results Report

[JHear6]

I’m trying to create a line chart with two reporting lines for;
1) # of Surveys sent out per week
2) # of Surveys Completed per week
Note Week Starting on Wednesday and ending on Tuesday.
I have two groupings in the report; (that are working correctly)
1) DatePart("ww", ({CustomerSurvey.CreatedDateTime}),crWednesday) - //which shows Surveys Sent
2) DatePart("ww", ({CustomerSurvey.CompletedDateTime}),crWednesday) - //which shows Surveys Completed
The chart will plot the first line of data without any problem, but the second line will not show.
Looking at the data, I think it is because there ends up to be two data points in one week and Crystal doesn’t know how to plot that.
I think the two data points are because most of the Surveys are Created and Completed in the same week number, but
A few of the Surveys are Created in one week and completed in another week.
I know that I have to fix this before the chart will work, but I’m not sure how to go about fixing it.
What I think that I need is a datepart that does Not relate to a field in the database so that the lines can be plotted independently of each other.

Any help would be great!!
Thanks,
Jeff

 

[JHear6]

Sorry, this is in Crystal Reports XI

 

[Charliy]

Let's assume there was only one survey sent out during a week, and it was returned during the same week.

Do you have one or two data records?

 

[JHear6]

One data record with two dates, Created Date and Completed Date. and there are two status, Open and Completed. I would like two different chart lines, one for total sent and one for total completed.
Hope that helps.