Working As Designed: MPG numbers don't match [non-bug] - Fuelly Forums

Click here to see important news regarding the aCar App

Go Back   Fuelly Forums > Fuelly Community Support > Fuelly Web Support and Community News
Today's Posts Search Click Here to Login
 
 
Thread Tools Display Modes
 
Prev Previous Post   Next Post Next
Old 06-25-2014, 10:58 AM   #9
Site Team
 
Join Date: Apr 2011
Posts: 176
The avg numbers, for any period, of any stats, are being generated via a miles / gallons formula. When we generate these averages we ignore all fuelups that don't have a MPG or don't have a miles value stored. A fuelup might not have a MPG for several reasons, you marked it partial, you marked the previous partial, you put in an excessive number of miles, say 5,000.

So when I ask the database to tell me your numbers, I get 18,200.20 miles and 1,351.437 gallons. If you figure that out, you will get 13.36 which is where the 13.4 average comes from.

What numbers did you use to arrive at 14.1?

The numbers shown in the "Total Miles Tracked" and "Total Gallons Fueled" mini stats will differ from these numbers as those are displaying the total distance and miles, regardless of the mpg status of the fuelups.

These are SUM(miles_last_fuelup) and SUM(amount) versus the formula used for averages, which is along the lines of SUM(miles_last_fuelup) and SUM(amount) WHERE mpg > 0 and miles_last_fuelup > 0

The only number that is an avg of avgs is the Running AVG displayed on the dashboard. I need to change the data structure of the stored last 10 fuelups to resolve that one.

See my test car: http://www.fuelly.com/car/acura/mdx/2009/freddie/298667

It illustrates what I am saying.

Miles / Gallons = 19.8 MPG
Sum of Avgs / 4 = 17.3 MPG
freddie is offline   Reply With Quote
 


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


» Fuelly iOS Apps
No Threads to Display.
» Fuelly Android Apps
Powered by vBadvanced CMPS v3.2.3


All times are GMT -8. The time now is 06:58 PM.


Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2025, vBulletin Solutions, Inc.