How to create 95th percentile of average page load time?

Avatar

Avatar

patricks6774671

Avatar

patricks6774671

patricks6774671

03-05-2018

Hello,

I'd like to create a metric in Workspace with a 95th percentile of the average page load time to eliminate outliers. I tried to build the metric by myself but couldn't succeed.

Here is how I tried it:

In calculated metric builder, I inserted the percentile function.

1478860_pastedImage_1.png

I then dragged the metrics "page load time" and "occurences" and divided the former by the latter one. For k, I entered 95, as I want to find the 95th percentile.

1478876_pastedImage_2.png

The result for the whole time period was 1,676 msec which can't be correct. In the right column, the average page load time is displayed without the percentile function. As you can see, these values are varying.

1478885_pastedImage_5.png

Looking forward to your answers.

Kind regards

Patrick

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

Gigazelle

Employee

Total Posts

1.9K

Likes

459

Correct Answer

734

Avatar

Gigazelle

Employee

Total Posts

1.9K

Likes

459

Correct Answer

734
Gigazelle
Employee

13-11-2018

You'd want to place the percentile function in an 'if' statement. Put the percentile in the compare operator, then the metric you want to measure in the value_if_true. For value_if_false, place the static number 0.

Let me know if you run into any issues getting this working!

Answers (0)