I have a bunch of raw data columns (say > 100), each of them have a spec, so I can calculate the Cpk (a measure of how distribution is doing agains the limit).
So my raw data in SQL looks like:
SN, Measure#1, Measure#2, .... , Measure#100
And my spec table in SQL looks like:
Measure #, USL, LSL
Measure#1, 100,0
Measure#2, 75,25
It doesn't seems like there is a logical way for me to relationally join the two tables together, so I manually created 100 calculated field, example for Measure#1 CPK looks like this:
(100-AVG([Measure#1]))/(3*STDEV([Measure#1]))
But now the spec changed, and that means I have to go back and edit 100s of calculated fields one by one.
Questions:
- Is there a way to make editing of calculated fields more easily? i.e. make a list of all the calculated fields and their formula, so I can easily go thru the formulas and apply the change
- Can I somehow manage limits for measures in a table, so that the calculated field refer to these limits and once the table is updated the calculated field result is also updated
I found myself a solution, here's the link to the post of my hack to bulk add parameters which can be used as USL/LSL for calculations: