I have to calculate Avg EV Trip Distance for each VIN in the week. This is done by summing all the EVTripDist and dividing by the total of unique VINs for that week.
Here are the fields which are needed
I am attaching sample date for your reference. We have so many records for VIN, EVTRIPDIST for a particular date ( For Ex: 1/21/2013).
I need to Sum "EVTRIPDIST" and calculate Distinct "VIN_C" for a particular date ( For Ex: 1/21/2013).