I'd recommend you to create a Time Dimension in your script. It'd be something (conceptual) like:
load AccountName, Date, DailyMileage
Month(Date) as Month,
Year(Date) as Year;
load distinct Date
Then, in the layout, you'd create a chart using the Year and Month fields and an expression like sum(DailyMileage).
hope this points you in the right direction