Splunk Search

Non-integer percentiles?

yplambert
New Member

I would like to find the 99.99th percentile of a value.

The perc(Y) function expects X to be an integer 1-99.

Any ideas?

Tags (1)
0 Karma
1 Solution

martin_mueller
SplunkTrust
SplunkTrust

Using p99.99(field) works fine for me:

index=_internal | timechart span=1h count | stats p99(count) p99.99(count) max(count)

Yields this:

  p99(count)  p99.99(count)  max(count)
1       6500          7000         7879

What Splunk version are you using?

View solution in original post

0 Karma

martin_mueller
SplunkTrust
SplunkTrust

Using p99.99(field) works fine for me:

index=_internal | timechart span=1h count | stats p99(count) p99.99(count) max(count)

Yields this:

  p99(count)  p99.99(count)  max(count)
1       6500          7000         7879

What Splunk version are you using?

0 Karma

yplambert
New Member

You are right! I tried it and it didn't work, but I must have done something else wrong; it works fine for me now. Thanks!

0 Karma

joebensimo
Path Finder

Maybe filter for all values greater than the 99th percentile, and then take the 99th percentile of that:

| eventstats perc99(Y) as ninetynine
| where Y> ninetynine
| stats perc99(Y)

However, this won't be quite right in cases that you have more than one event with the 99th percentile value.

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Kubernetes Alerts That Work Out of the Box with AutoDetect detectors in Splunk ...

A deployment rolls out slowly, one pod sits not ready for a few minutes, and whoever is on call gets an alert ...

Observability at Your Fingertips Directly From Splunk Platform—for Free

At .conf, we announced our roadmap to bring observability foundations to Splunk Platform. Bringing metrics and ...

Accelerate Splunk App Development with AI

  Learn how to automate the repetitive parts of your build cycle.   Watch On-Demand   Replay the Accelerate ...