Card #3562 · Grafana
Lack of arithmetic operations for Elasticsearch queries
Merchants are struggling to perform basic mathematical operations, such as subtraction and division, between different Elasticsearch query results within Grafana. They are able to perform these calculations directly in Elasticsearch but cannot find a way to achieve the same results in the Grafana UI.
Pain score
0.51/ 1.00 · weighted product of four components
Reach0.63distinct authors (log-normalized)
Recency1.00freshness decay, half-life months
Engagement0.60upvotes + comments, normalized
Monetization0.25willingness-to-pay cues in evidence
§ Evidence — 3 verified quotes
I have a use case that involves taking one query, subtracting it from another, then dividing by the total time. Would it be possible to do this in Elasticsearch with Grafana?
I am trying to write an elasit search query in grafana to subtract Total field from used field.
I want to draw line chart for avg posts per active users for that hour [B/A]. How I can divide result of B by A for each hour.
Comments are a Pro feature — join the conversation, share what you've shipped, hear what others are building.
Upgrade to Pro