Timeseries Value Lookup

The dataset present:

Time. Odometer reading t1, 120 t2, 210......

I am trying to find out how many miles the car has driven in the last 30 days in QuickSight.On reviewing a help document(https://docs.aws.amazon.com/quicksight/latest/user/periodToDateAvg-function.html) I thought of using PeriodTodateAvg function.

periodToDateAvg(Odometer reading,timeStamp,MONTH)

The above formula is giving me null values.

It would be really helpful if someone could guide me. Thank you