D
DialAround
I need to calculate moving ranges in either a report or query. Currently my
query returns TestTime (ascending) and TestResult. The moving range is the
absolute difference between two consecutive samples.
TestTime TestResult MovingRange
8am 20 --
9am 24 4
10am 21 3
11am 26 5
Once all the moving ranges are calculated, I need to report the average of
the moving ranges.
query returns TestTime (ascending) and TestResult. The moving range is the
absolute difference between two consecutive samples.
TestTime TestResult MovingRange
8am 20 --
9am 24 4
10am 21 3
11am 26 5
Once all the moving ranges are calculated, I need to report the average of
the moving ranges.