I apologize for the clickbait-y title, but it does describe my problem. I’m new to Grafana (but not to BI/DataViz tools) and I have to confess that my first experience with this tool has been disappointing. My first task in a new job is to create a dashboard to show failures in a data ingestion pi…

I would be very disappointed with implementation, which calculates data in my browser. Quite good for small datasets, but then any manager will select last 5 year data with 1 sec aggregation and he will be complaining that his browser/machine is unresponsive. So it is better to calculate it in the …

Thank you for your reply! I was not aware that Grafana does calculations client-side. I agree what I’m doing is probably not best practice. Even so, I would expect calculations to be slow, perhaps, but not mathematically incorrect. That’s just inexcusable even if what I’m doing is not best practi…

Example dashboard with metric math grafana-aws-cloudwatch-dashboards/aws-cloudwatch-usage-metrics at master · monitoringartist/grafana-aws-cloudwatch-dashboards · GitHub Use it as an example to see how is correct syntax and then it will be piece of cake.

I’m afraid I still don’t see the syntax examples I need. The forumula I want is: (Total - Success) / Total * 100 I can get Total easily enough: select sum(TopicMatch) from “AWS/IoT” where RuleName = ‘myRule’ However, I haven’t yet figured out how to build a query that performs mathematical opera…

Actually, maybe I’m still doing things wrong. The query I wrote above that works still gives me a time series of data and I want a scalar value.

Sigh… A panel with one query works: select sum(TopicMatch) from “AWS/IoT” where RuleName = ‘myRule’ If I change the query, this works: select sum(Success) from “AWS/IoT” where RuleName = ‘myRule’ When I put both queries on the same panel, I get no data back.The tooltip in the magenta triangle s…

SLO calculation for ALB: [image]

I believe that’s exactly what I did in my first post in this thread. Look in my .json at “refId”: “C”. It’s giving me mathematically incorrect results.

No, your original C query is ($A - $B) / $A * 100 - that’s incorrect syntax. $A means in this case Grafana dashboard variable with name A, which is very likely not defined, so it isn’t interpolated. CloudWatch math will get ($A - $B) / $A * 100 for evaluation and $A means nothing for CloudWatch, bec…

Jangaraj, thank you for your feedback. The reason I was referencing my prior queries as $A and $B is because that’s what was recommended to me in this thread . I will try these solutions and report back.

Disappointing First Experience with Grafana - can't do simple math?

Grafana Stat Panel

jangaraj December 16, 2021, 6:04pm 8

SLO calculation for ALB:

Total 5xx/4xx % calculation

Calculate error rate from two rows based on dimension

Can't do basic division with my metrics

How to populate CloudWatch metric with zeros?

Topic		Replies	Views
Math Operation (Percentage calculation) issue for CloudWatch metrics through grafana Cloudwatch grafana-roles , grafana-ui	4	3455	March 21, 2025
Expression query in Stat panel Grafana cloudwatch , stat-panel	4	4633	October 16, 2023
Math expressions broken in AWS Grafana 10.4? Grafana expressions	5	569	September 30, 2024
Cannot use Math Expression in Grafana (Data source from Cloudwatch) Grafana	0	381	July 31, 2019
Make gauge panel show absolute calculation instead of mean Time Series Panel cloudwatch	0	2867	November 24, 2020

Disappointing First Experience with Grafana - can't do simple math?

Related topics