Crystal Report graph

Genius123
Genius123 used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
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

Author

Commented:
mlmcc, I'm sorry but I had since edited the question.  could you take another look?
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
Try using this formula

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

mlmcc
Introduction to Web Design

Develop a strong foundation and understanding of web design by learning HTML, CSS, and additional tools to help you develop your own website.

Author

Commented:
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.
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
I think the problem is the main report is grouping first on the engineer.

Try putting that part of the chart into the subreport

mlmcc

Author

Commented:
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!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial