Avatar of Genius123
Genius123
Flag for United States of America asked on

Crystal Report graph

Hello,

On the second data axis, I'm trying to use the running total parameter called {#Efficiency Week Total}.  It's not available for use.  The value in the 3-15 week should be 0.38 as it is in the subreport below.  If running totals are not available for use in a graph, how else can I accomplish this?

Thanks for your help.  I've attached the files.  The main report is the one that ends in EE.

Joel
Engineer-EfficiencyEE.rpt
Engineer-EfficiencySub.rpt
Crystal Reports

Avatar of undefined
Last Comment
Genius123

8/22/2022 - Mon
Mike McCracken

Change the chart to use Distinct COunt on the Engineer field.

By counting your COuntEngineers summary it is always the same value for a week.

mlmcc
Genius123

ASKER
mlmcc, I'm sorry but I had since edited the question.  could you take another look?
Mike McCracken

Try using this formula

Sum ({@Total Hours}, {tblRevisions.CheckerComplete}, "weekly") / 40 / DistinctCount ({tblRevisions.Engineer}, {tblRevisions.CheckerComplete}, "weekly")

mlmcc
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
Genius123

ASKER
It's not working.  Part of the formula that is not working is this:

DistinctCount ({tblRevisions.Engineer}, {tblRevisions.CheckerComplete}, "weekly")

It returns a value of 1 for each week in the chart.  The values should be like 6 or 7 or 8.
ASKER CERTIFIED SOLUTION
Mike McCracken

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Genius123

ASKER
You were right, it was the grouping.  The final fix was to make a subreport for the chart, delete the first grouping by engineer, and change the formula to this:

Sum ({@Total Hours}, {tblRevisions.CheckerComplete}, "weekly") / (40 * DistinctCount ({tblRevisions.Engineer}, {tblRevisions.CheckerComplete}, "weekly"))

Thanks for your help!