bowieknife
Technical User
I am tracking "[Total Shipments]" in a table ("TblServiceMetrics") by date and displaying this data in a "line-dot" chart on a report. How can I add the upper and lower control limits and center line to the chart? I have a query that calculates each with the following formulas:
Upper Control Limit: Avg([Total Shipments])+((3*(Avg([Total Shipments])/Count([Total Shipments]))))
Center Line: Avg([Total Shipments])
Lower Control Limit: Avg([Total Shipments])-((3*(Avg([Total Shipments])/Count([Total Shipments]))))
but the query results in one answer (which is mathematically correct) and this can't be balanced across the entire range (10+ records and growing indefinitely). If this were excel I could drop in the extra calculated column, but I am an Access fan. Please help.
JB
Upper Control Limit: Avg([Total Shipments])+((3*(Avg([Total Shipments])/Count([Total Shipments]))))
Center Line: Avg([Total Shipments])
Lower Control Limit: Avg([Total Shipments])-((3*(Avg([Total Shipments])/Count([Total Shipments]))))
but the query results in one answer (which is mathematically correct) and this can't be balanced across the entire range (10+ records and growing indefinitely). If this were excel I could drop in the extra calculated column, but I am an Access fan. Please help.
JB
