Charting the highest distinct count per month

[Kevinski]

Hi

I have a report which counts the number of service calls a user logs each month. I run it for the previous month for the top 20% of users.

I now want to create a rolling 13 month report which plots the highest count per month. I have the formula for 13 months in my record selection and I have grouped by month and username with call count.

How do I create a formula which isolates the highest count per month and then plot it on a line chart?

 

[BarbaraFuhrmann]

I think it shoud work like this:

Create a chart with the chart assistant, put the month in "on change of"-field and the number of calls in the "show value(s)"-field below. Then change the automatically choosed function "sum" for the value-field to "maximum".

HTH

 

[IdoMillet]

The problem is that you need to first count, and then select the maximum of these counts.

One easy way to do this is to return from the DBMS these counts. You don't state which DBMS or which version of Crystal, so it's tough to cover all possibilities. In CR 9 you could simply create a command (SQL statement). You can create a View (Query in MS Access) in the source Database and use it as the data source...

hth,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[Kevinski]

Thanks for your suggestions. In the end I solved this myself (using V10 by the way) by doing a 'Top 1' group sort on the 'User name' group (which I had already calculated the count of calls on. Then I charted this 'Top 1' for each month.

In the end this seemd so easy that maybe its a V10 enhancement?

Anyway thanks again.

 

[popper]

I have a vba routine initiated by a button on a Microsoft Access form. The routine loops several times. I want the progress to be reflected in a text box on the form. So I have a line of code that says something like:

me.textbox = loop_variable

However, the form only gets updated when the routine finishes, and not during the running of it.

I have tried requery, and using the timer event but to no avail.

Can anyone help?

With thanks