How to find/extract the corresponding value on x axis for y max (peak) value ?

saad — Sun, 17 Mar 2024 14:00:21 GMT

I need a quick way to extract the peak values of Y-axis and its corresponds on X-Axis.

The plot was performed in Graph Builder. X-axis is log scale.

Re: How to find/extract the corresponding value on x axis for y max (peak) value ?

Craige_Hales — Sun, 17 Mar 2024 14:25:00 GMT

Try the crosshair tool.

(view in My Videos)

Re: How to find/extract the corresponding value on x axis for y max (peak) value ?

GregF_JMP — Mon, 18 Mar 2024 15:26:00 GMT

Hello-
In addition to the graphic analysis, a formula column in the data table can identify the peak Y value of your column :Output,

There are multiple traces shown on the graph, so assume an identifier we will call :Batch.

Make a new column, right click to edit formula: (assume column name Input_at_Peak)

If( Col Maximum( :Output, :Batch ) == :Output,
	:Input,
	.
)

This will determine the rows where the current value of :Output matches the maximum :Output

for that :Batch. In these peak rows, the value of the :Input value will be duplicated, otherwise the value will be missing.

Once there is a single value per :Batch, and the rest missing- any summarization function (e.g. mean, min, max) when given one value and the balance missing- will return the one value.
Depending on where you would like the result to appear:

In a separate table- use Table Menu/Summary- calculate the Mean(Input_at_Peak), with group Batch
Within the same data table- if you wanted the same value in all rows, a similar formula column approach of Col Mean( :Input_at_Peak, :Batch )

topic Re: How to find/extract the corresponding value on x axis for y max (peak) value ? in Discussions

How to find/extract the corresponding value on x axis for y max (peak) value ?

Re: How to find/extract the corresponding value on x axis for y max (peak) value ?

Re: How to find/extract the corresponding value on x axis for y max (peak) value ?