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
You are not logged in. Log in to post an answer.
A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.