# Percentiles below 50 not returning data

**URL:** <https://community.influxdata.com/t/percentiles-below-50-not-returning-data/57967>\
**Category:** InfluxDB 1\
**Created:** [September 24, 2025, 9:37am UTC](https://community.influxdata.com/t/percentiles-below-50-not-returning-data/57967 "2025-09-24T09:37:04Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![dewi-ny-je](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/dewi-ny-je/32/5355_2.png) [@dewi-ny-je](https://community.influxdata.com/u/dewi-ny-je)\
**Post date:** [September 24, 2025, 9:37am UTC](https://community.influxdata.com/t/percentiles-below-50-not-returning-data/57967/1 "2025-09-24T09:37:04Z")

</div>

I’m preparing a graph using grafana and influxQL. I have hourly energy prices and I want to plot both the average, the 70th percentile and the 30th percentile, to look how the daily profiles look like.

I’m requesting this query:

`SELECT percentile("value", 70) FROM "€/kWh" WHERE ("entity_id"::tag = 'current_electricity_market_price') AND $timeFilter GROUP BY time(1d) fill(previous)`

Using percentiles from 50 and up works, but no data is returned below 50. What can be the reason?

---

<div class="post-metadata">

**Author:** ![suyash](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/suyash/32/15791_2.png) [@suyash](https://community.influxdata.com/u/suyash)\
**Post date:** [September 25, 2025, 11:26am UTC](https://community.influxdata.com/t/percentiles-below-50-not-returning-data/57967/2 "2025-09-25T11:26:45Z")

</div>

I think you’ve run into this issue: [InfluxQL functions | InfluxDB OSS v1 Documentation](https://docs.influxdata.com/influxdb/v1/query_language/functions/#percentile-compared-to-other-influxql-functions)

---

<div class="post-metadata">

**Author:** ![dewi-ny-je](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/dewi-ny-je/32/5355_2.png) [@dewi-ny-je](https://community.influxdata.com/u/dewi-ny-je)\
**Post date:** [September 25, 2025, 1:48pm UTC](https://community.influxdata.com/t/percentiles-below-50-not-returning-data/57967/3 "2025-09-25T13:48:46Z")

</div>

Then I’ll use flux instead of influxQL