I have this requirement now to break the data into different bands when the AR value range is >5K.
For the above example, the aggregated output is like below (I had to split on year/make/model and then use the Min(AR) and Max(GR) to arrive at this record).
|Year||Make||Model||AR (Min)||GR (Max)|
But now the requirement has been changed to have them split into different bands(whenever the AR value diff by 5k) like below. I would have already arrived at Min -Max and combine into a single record by this time (even before checking the 5K difference in AR)
|Starting position for the 5k tolerance||12450||18650|
|Suggest the we always |
default to the lowest qualifying band
(prev Max -100)
Any help is appreciated.