Help Pulling Data for Dynamic Axis Limit Setting

amurphy

Hello,

 

I am attempting to determine the axis limits on a graph depending on the current data plotted so that all reference lines and data points are visible after user inputs.

 

The axis limit set will either be the value of the USL / LSL reference line or the highest / lowest data point plotted. The graph in use in a Variability Chart and the data are the values in Column 2 grouped by Column 1.

 

Initially I thought I could do this by determining the min/max of the two values where the reference to the data was determined by the Col Minimum function with the <ByVariable argument. But it appears this function can not be used this way. 

 

Var1_Min = Eval( Min((LSL[1]*0.95), Col Minimum( :Column 2, :Column 1["Group1"] )));

I've spent a lot of time searching and can't seem to find a function that does what I need to - any ides?

 

 

 

amurphy

Thank you for your response Jim!

 

Unfortunately, I don't have a single spec limit for my column as there's a distinction between the values based on another column so I haven't found a way to do traditional column spec limits yet without completely splitting my data into two tables.

 

I was ultimately able to find the solution to my problem by using Get Rows Where:

<BR />dt = Current Data Table();
G1 = dt << Get Rows Where (:Column 1 == "Group1");
G1_Min = Eval( Min((LSL[1]*0.95), Min(:Column 2[G1])));
G1_Max = Eval( Max((USL[1]*1.05), Max(:Column 2[G1])));<BR />dt << clear select;
<BR />dt = Current Data Table();
G2 = dt << Get Rows Where (:Column 1 == "Group2");
G2_Min = Eval( Min((LSL[2]*0.95), Min(:Column 2[G2])));
G2_Max = Eval( Max((USL[2]*1.05), Max(:Column 2[G2])));<BR />dt << clear select;

Then to graph within dispatch section (for the first graph, second is duplicate with 1->2):

Dispatch ({Min(G1_Min), Max(G1_Max), Inc( Eval((G1_Max - G1_Min) / 7))),
Add Ref Line( LSL[1], "Solid", "Medium Dark Blue", "LSL", 1 ),
Add Ref Line( USL[1], "Solid", "Medium Dark Blue", "USL", 1 )}

* Note I forgot to mention in my original question that the USL/LSL are already defined in a lists and used for the reference lines.