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