Percentiles below 50 not returning data

InfluxDB 1
1

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?

2

I think you’ve run into this issue: InfluxQL functions | InfluxDB OSS v1 Documentation

3

Then I’ll use flux instead of influxQL

1 Like