topic Pulling Row Data for each Max Value from a Column in Discussions

Pulling Row Data for each Max Value from a Column

BatteryTamer359 — Thu, 10 Aug 2023 19:20:08 GMT

I have a table with the first column being my time varying X-axis variable and all the remaining columns being the Y-axis response columns. I'm looking to create a subset table based on the Maximum value of each Y-axis column. I.E. The subset table should be all the rows in the original table that have a Maximum value in one of the corresponding Y-axis columns. That way I can compare at what X-axis value all of my Y-axis maximums occurred. (Even better would be the X-axis value paired with the single Y-axis maximum, but we'll get there later)

Is there a simple way to do this through Summary or Subset tables?

Re: Pulling Row Data for each Max Value from a Column

jthi — Thu, 10 Aug 2023 19:45:39 GMT

I think using Stacked column might be the easiest option if I understand correctly what you want.

Start data:

Stack the data columns (column 2 and column 3):

Add new formula column to check if row is max for specific Label

:Data == Col Max(:Data, :Label)

From here you have 1 on those rows which are maximum for labels

Re: Pulling Row Data for each Max Value from a Column

BatteryTamer359 — Thu, 10 Aug 2023 20:09:50 GMT

Yup, that's what I was looking for. I like the Stacked idea. I was just playing with using a Formula to add the flags, but I think the Stacked column would make that cleaner!