Distinct count for Averaging

[deborahyr]

Using Crystal XI, I have a succession plan report that is grouped as follows:

Group by: Manager ID, Plan, Readiness
Detail: EEID, Age, Tenure

How do I get my report to distinct count EEID in order to get an overall average age, tenure for all EEs, regardless of Plan or Readiness?

 

[lbass]

You should show some sample data using the displayed fields, so we could see how the data repeats (which I'm assuming is the problem). Also, what tables are you using? How are they linked?

You can probably insert a running total that does a distinctcount of EEID on change of some field or group, but we don't really know clearly what you are trying to do.

-LB

 

[deborahyr]

That was exactly my approach to doing this.

I had a running total:
distinct count - CandidateID
Evaluate:formula - if <successor> = 1 then average<age as of>
Reset: on change of group - <year>

But this was thought to add ee's multiple times if they were on the report as a <successor> multiple times and therefore skew the average age.

The average age would be displayed in a bar chart.

 

[lbass]

If you have duplicating records, and you want the average age, then your running total should be set up to do an average of {@age}, evaluate on change of group (EEID}. This assumes that you insert an inner group on EEID. You could also just sort by this field. I don't have a clue how the year fits in, since it isn't any of the fields you have shown so far.

Please show some sample data at the detail level, and provide more relevant information about what you are trying to do.

-LB