Noob question? Finding maximum of setsub of data
I have a data source (CSV) with TestRun,Time,Result.
TestRun identifies when a test was run.
Time is time since the start of the test.
Result is the measured value at that time.
I have a large number of unique TestRuns. I'd like to perform some calculations but for the life of me I can't figure out how any of the loops etc work. I've also tried tutorials, time series extension etc, and tried cutting and pasting XML from other answers in this forum. Nothing seems to work (BTW There is a smiley face on one of the XML examples which screws it up.)
The calculations I'd like to perform are:
What is the maximum value of Result for the TestRun? (From this result, I can find the earliest time for the maximum result)
I can think of a number of ways to do this with a programming language, but just can't get my head around doing it within RapidMiner.
Any help would be appreciated?