Bar chart comparison data...

[ije]

Hello,

From a database of helpdesk records, I need to show in a single graph how many calls where logged each month, and how many were closed that month ( regardless of when they were logged).

Calls logged = MonthName (Month ({Call.RecvdDate}), True)
Calls closed = MonthName (Month ({Call.ClosedDate}), True)

I dont know where I should start on for this one - I can produce seperate graphs easy enough, but need side by side bars ( no opened, no closed ) for each month.

Any pointers???????

 

[lbass]

I always try to do everything right in Crystal, but I fooled around trying to come up with a solution to your problem, and the only method I could come up with depends on creating the graph in Excel. Is that an option?

In case it is, try something like this: For your record select, choose the date range that includes the time period of interest using a statement something like this:

{Call.RecvdDate} in Date(2003, 01, 01) to Date(2003, 05, 31) or
{Call.ClosedDate} in Date (2003, 01, 01) to Date(2003, 05, 31)

Insert a crosstab, with {Call.RecvdDate} as the row, and {Call.ClosedDate} as the column, and for each, choose group options and select "printed for each month" and then use a distinctcount on the {Call.ID} as the summary field.

Export this to Excel, and then select the row which contains the {Call.ClosedDate} column totals and copy it. Then select the cell corresponding to the same month total for {Call.RecvdDate} and choose paste special and transpose, so that the {Call.ClosedDate} total row is now a column next to the total columns for {Call.RecvdDate}. Then you can drag the total columns over to the month labels, add appropriate headings to the columns, select the resulting table as the data source, and insert a bar chart.

This works, it's just a matter of whether you can do the export to Excel. I'm curious whether someone else can come up with a way to do this within Crystal though.

-LB

 

[ije]

thanks LB,

Excel is an option - not my first one though - I will try it out and get back to you.

Thanks a lot for your time and help...
ije