I'm not sure of the proper approach for this query. I have a list of events,one event per day, with fields min,max and base. Starting with any date I need to pull the base for that date as well as the highest Max in a range span of 3 or 4 events [Note: I say events because because the log has missing dates].
as an Example snippet:
Date,Min,Max,Base
2014-07-23,8.66,8.79,8.59
2014-07-22,8.68,8.74,8.58
2014-07-21,8.59,8.69,8.49
2014-07-18,8.59,8.73,8.45
I would need to return the date, its base and the highest Max in the range:
Date, Base, Max
2014-07-18, 8.45, 8.68
For creating the ranges, should I should use a span or a bin with a foreach or is there a more appropriate method?
... View more