As my experience, if you use SNMP, it’s very difficult to get the percentile.
In my setup, first I use SNMP to build the traffic, I use elasticsearch by the way, and I just have the Derivative value from SNMP IfInOctets, then I tried to get the percentile, but it’s too difficult, even in the elasticsearch can do the query, but not in Grafana.
I suggest use netflow if you want to get the percentile. I have the percentile right now since using netflow from the network devices, especially cisco…
You can use netflow_exporter to the prometheus from this:
https://github.com/neptune-networks/flow-exporter
Regards,
Fadjar Tandabawana