Comparing with data 2 weeks ago

We’re looking to compare FID data from 2 weeks ago. Not sure if it’s giving us the correct value. Please advise. Thank you.

Hey @grayat1

Can you share a screenshot of what you see if you change your query to:

FROM PageViewTiming SELECT percentile(firstInputDelay, 75) SINCE 2 WEEKS AGO COMPARE WITH 2 WEEKS AGO WHERE appName = 'myApp' TIMESERIES

That’ll show us what the comparison value was. Based on an increase of 1700%, I expect the actual value to be 0. But adding that TIMESERIES clause should confirm that for us.