1
votes

I'm having some trouble creating a bell curve chart in Jaspersoft Reports.

I have so far been able to produce a chart displaying the Normal Distribution, but unsure of how to standardize it to produce a bell curve.

My query:

DECLARE @JobNo  VARCHAR(50) = $P{pJobNo}
SELECT  Bird, (Bird-Calc.Mean)/Calc.StanDev AS Dev
FROM fn_Live_Weights($P{pJobNo})
OUTER APPLY (
    SELECT Mean, StanDev
    FROM fn_Live_Weights_Bell_Curve_Calculations($P{pJobNo})
) Calc

My result: Normal Distribution Chart