I'm new to Line graphs, so any help with this would be appreciated. I'd like to create a line graph in Crystal Reports with the last 24 months displayed on the x-axis.
On the y-axis I need a integer value that represents a count for:
a."Received" support tickets
b."Completed" support tickets.
I've attached a screen shot of what it should look like (I was able to mock something up quickly in Excel). Here is the problem that I'm having with creating this graph in Crystal...my counts are not showing correctly for "Completed" support tickets because I'm using the "Received" date (sort order = for each month) along the x-axis.
If I switch the "On Change Of" option from "Received" date to "Completed" date, then my "completed" count is correct, but my "Received" count is incorrect. What are my options for getting around this problem or maybe I've missed something all together?
Hope I've explained this good enough for someone to provide guidance. Let me know if more explanation is needed.