Get column value related to another column minimumHi,
I am looking for easier way (without scripting) for extract the X column value of Y axis minimum for each plot/charts.
I have N columns chart, the first column is the X axis. the other is sets of measurements\reading.
I want to get the X value which related to each set of plots.
I did it by script but i want to know if there is an easier way.
attached example for data format.
following the script I wrote. that may help to understand the result I want.
dt=Current Data Table();
ds=New Table();
ds<<NEW column=""></NEW>
BR,
Yoav
Advanced Statistical ModelingAutomation and ScriptingMass CustomizationQuality and Process EngineeringSharing and Communicating ResultsRe: Get column value related to another column minimumHi,
Here is a point-and-click way; it is actually pretty efficient.
1) Stack the table: place the y columns into "Stack Columns", type "Y min" into the 'Stacked Data Column' text edit box. Hit OK.
2) In the stacked table, select the Label and Ymin columns, right-click on the blue-shaded column header, and select Sort > Ascending
3) Select just the Label column, then select from the main menu Rows > Row Selection > Select Duplicate Rows
4) Right-click in the blue region of the selected rows and select Delete Rows
The resulting table has the desired summary info:
