I was creating a web performance dashboard using median and percentile functions. However, I have noticed that median and p50 don’t have the same value. They differ a little bit, however, theoretically, they should be the same.
Here 2 queries I was using:
SELECT FILTER(percentile(largestContentfulPaint, 50), where(timingName = 'largestContentfulPaint')) as 'Largest Contentful Paint' FROM PageViewTiming WHERE pageUrl LIKE '%/register/%' AND deviceType = 'Desktop' SINCE 1 week ago
with the result 2.844s
SELECT median(largestContentfulPaint) FROM PageViewTiming WHERE pageUrl LIKE '%/register/%' AND deviceType ='Desktop' SINCE 1 week ago
with the result 2.868s
What could be the reason for different values?
Thank you in advance!