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