Thank you for the quick response.
I do think that is close, but I am trying to not SUM & while trying to replicate your example, I see ONLY gave me a '-' value if I swap SUM in your equation with ONLY.
The chart I'd like to get, but cannot is like this:
. Vehicle_No . 1 2 3 Min_Date 5/16/2017 1:00 5/15/2017 1:00 5/14/2017 1:00 Battery Voltage 61 62 63
I want to find the Min_Date & determine what the value of the Battery Voltage field is for the Min_Date.
It appears I have solved it.
Root Cause: Date format was left to Default and I should have updated that to reflect what I actually have.
A couple of other threads helped me identify this & once resolved, another thread held the equation I needed.
The equation I needed is as follows:
- The average of the single MAX(Date) is one value.
My Load Script:
SET TimeFormat='h:mm:ss TT';
SET DateFormat='M/D/YYYY h:mm:ss TT';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
Load Date(Date_Time) as Date, Vehicle_No, Battery_Voltage Inline
5/17/2017 1:00:00 AM, 1, 55
5/16/2017 2:00:00 PM, 2, 56
5/17/2017 3:00:00 AM, 3, 57
5/17/2017 4:00:00 PM, 1, 50
5/16/2017 5:00:00 AM, 2, 59
5/17/2017 6:00:00 PM, 3, 60
5/16/2017 7:00:00 AM, 1, 61
5/15/2017 8:00:00 PM, 2, 62
5/14/2017 12:00:00 PM, 3, 63