Long story short I set up a database and a job to query all the stats off the Tesla API. So I already have data, what I don't know is what formula I should configure into my report to calculate degradation over time. For those that may not be aware here are all the statistics you can get off the API.
backseat_token,
backseat_token_updated_at,
calendar_enabled,
color,
display_name,
id,
id_s,
notifications_enabled,
option_codes,
remote_start_enabled,
state,
tokens,
vehicle_id,
vin,
api_version,
autopark_state,
autopark_state_v2,
autopark_style,
calendar_supported,
car_type,
car_version,
center_display_state,
dark_rims,
df,
dr,
exterior_color,
ft,
has_spoiler,
homelink_nearby,
last_autopark_error,
locked,
notifications_supported,
odometer,
parsed_calendar_supported,
perf_config,
pf,
pr,
rear_seat_heaters,
remote_start,
remote_start_supported,
rhd,
roof_color,
rt,
seat_type,
spoiler_type,
sun_roof_installed,
sun_roof_percent_open,
sun_roof_state,
third_row_seats,
valet_mode,
vehicle_name,
wheel_type,
gps_as_of,
heading,
latitude,
longitude,
shift_state,
speed,
gui_24_hour_time,
gui_charge_rate_units,
gui_distance_units,
gui_range_display,
gui_temperature_units,
battery_current,
battery_heater_on,
battery_level,
battery_range,
charger_actual_current,
charger_phases,
charger_pilot_current,
charger_power,
charger_voltage,
charge_current_request,
charge_current_request_max,
charge_enable_request,
charge_energy_added,
charge_limit_soc,
charge_limit_soc_max,
charge_limit_soc_min,
charge_limit_soc_std,
charge_miles_added_ideal,
charge_miles_added_rated,
charge_port_door_open,
charge_port_latch,
charge_rate,
charge_to_max_range,
charging_state,
est_battery_range,
eu_vehicle,
fast_charger_present,
fast_charger_type,
ideal_battery_range,
managed_charging_active,
managed_charging_start_time,
managed_charging_user_canceled,
max_range_charge_counter,
motorized_charge_port,
not_enough_power_to_heat,
scheduled_charging_pending,
scheduled_charging_start_time,
time_to_full_charge,
trip_charging,
usable_battery_level,
user_charge_enable_request,
driver_temp_setting,
fan_status,
inside_temp,
is_auto_conditioning_on,
is_front_defroster_on,
is_rear_defroster_on,
outside_temp,
passenger_temp_setting,
seat_heater_left,
seat_heater_rear_center,
seat_heater_rear_left,
seat_heater_rear_left_back,
seat_heater_rear_right,
seat_heater_rear_right_back,
seat_heater_right,
smart_preconditioning
backseat_token,
backseat_token_updated_at,
calendar_enabled,
color,
display_name,
id,
id_s,
notifications_enabled,
option_codes,
remote_start_enabled,
state,
tokens,
vehicle_id,
vin,
api_version,
autopark_state,
autopark_state_v2,
autopark_style,
calendar_supported,
car_type,
car_version,
center_display_state,
dark_rims,
df,
dr,
exterior_color,
ft,
has_spoiler,
homelink_nearby,
last_autopark_error,
locked,
notifications_supported,
odometer,
parsed_calendar_supported,
perf_config,
pf,
pr,
rear_seat_heaters,
remote_start,
remote_start_supported,
rhd,
roof_color,
rt,
seat_type,
spoiler_type,
sun_roof_installed,
sun_roof_percent_open,
sun_roof_state,
third_row_seats,
valet_mode,
vehicle_name,
wheel_type,
gps_as_of,
heading,
latitude,
longitude,
shift_state,
speed,
gui_24_hour_time,
gui_charge_rate_units,
gui_distance_units,
gui_range_display,
gui_temperature_units,
battery_current,
battery_heater_on,
battery_level,
battery_range,
charger_actual_current,
charger_phases,
charger_pilot_current,
charger_power,
charger_voltage,
charge_current_request,
charge_current_request_max,
charge_enable_request,
charge_energy_added,
charge_limit_soc,
charge_limit_soc_max,
charge_limit_soc_min,
charge_limit_soc_std,
charge_miles_added_ideal,
charge_miles_added_rated,
charge_port_door_open,
charge_port_latch,
charge_rate,
charge_to_max_range,
charging_state,
est_battery_range,
eu_vehicle,
fast_charger_present,
fast_charger_type,
ideal_battery_range,
managed_charging_active,
managed_charging_start_time,
managed_charging_user_canceled,
max_range_charge_counter,
motorized_charge_port,
not_enough_power_to_heat,
scheduled_charging_pending,
scheduled_charging_start_time,
time_to_full_charge,
trip_charging,
usable_battery_level,
user_charge_enable_request,
driver_temp_setting,
fan_status,
inside_temp,
is_auto_conditioning_on,
is_front_defroster_on,
is_rear_defroster_on,
outside_temp,
passenger_temp_setting,
seat_heater_left,
seat_heater_rear_center,
seat_heater_rear_left,
seat_heater_rear_left_back,
seat_heater_rear_right,
seat_heater_rear_right_back,
seat_heater_right,
smart_preconditioning