Card #3487 · Grafana
Limited query capabilities and calculation errors in InfluxDB
Merchants are struggling with InfluxDB's limited query language, specifically the inability to perform joins between measurements and restrictions on mixing aggregates with raw fields. Additionally, some users report incorrect results when using aggregation functions like count(), mean(), and median().
Pain score
0.20/ 1.00 · weighted product of four components
Reach1.00distinct authors (log-normalized)
Recency1.00freshness decay, half-life months
Engagement0.87upvotes + comments, normalized
Monetization0.25willingness-to-pay cues in evidence
§ Evidence — 5 verified quotes
I did not find a query in influx to support joins (from what I can see it only supports joins based on time).
InfluxDB query language is very limited in its capability (compared to Graphite)
InfluxDB Error Response: error parsing query: binary expressions cannot mix aggregates and raw fields
Does anybody have an idea why the row number 7 (7:Array[1523404800000,2]) returns number 2 for the count()? There should be one as there was no alarm event…
Why is the result of median() , mean() , and sum()/sum() wrong here?
Comments are a Pro feature — join the conversation, share what you've shipped, hear what others are building.
Upgrade to Pro