Charting summary information...

[CRCRCR]

Hi,

I'm using CR XI, Oracle DB, via ODBC.

I'm trying to chart analytical results, and struggling to find a complete solution.

A simplified version of my data is

Sample --> Test -- > Result. 3 tables.

for the moment, I'm developing the report with just a small subset of results using record selection, later I'll be grouping to display multiple charts.

Example data

Sample Test Result

1 pH 7.5
2 pH 7.7
3 pH 7.9
4 pH 8.0
5 pH 8.5
6 pH 8.7


I would like to produce a Line chart, that plots the pH result on the Y-Axis, and the sample number on the X-Axis.

This much is simple.

I would also like to be able to plot, the average, StdDev, Min/Max of all the pHs, (Average +/- 3 StdDevs) as horizontal lines on the chart.

There is the capability of adding a trendline, to the chart, but this give me limited options.

I've also done summary operations, i.e MIN, MAX of the pH Value, but have failed to have them appear on the Chart alongside the real values of pH.

I've tried doing the transparent chart trick, where two seperate charts are on over each, but I cannot seem to chart the summary vlaues.

There is also one other piece of data a simple upper and lower limit, that is in the Analysis Table, (which joins to the TEST table) which defines a static upper/lower limit for that analysis. For example the pH Upper limit would be a fixed10, while the lower would be a fixed 5. This piece of data is proving difficult to chart too, as a horizontal line.

Are these things impossible to acheive?

Kai.

 

[lbass]

You should be able to create formulas for each,e.g.:

average({table.result})

These formulas are available in the chart expert for charting. Add them as summary fields. The only one I wasn't sure of was how to implement the formula for average +/- 3 standard deviations, as I'm unsure of the math involved.

-LB

 

[CRCRCR]

Thank you very much.

You've sent me on my way.

I'm not sure why I never managed to use simple formulae before, I guess I was just looking for the hard way.

For the record, my Standard Dev formula, is just as simple

Average({RESULT.VALUE}) + 3*StdDev({RESULT.VALUE})

Kai.