I have no problems getting my panels to work when I query for cloudwatch ECS data. They display properly. However, when I try to do any math expressions on them, it breaks and throws the Query Error seen in the pic attached. My queries work as long as I don’t include math expressions. This worked in version 8 of Grafana, I had many dashboards break, and all of them had math expressions. What could cause this?
Edit: Formula doesn’t matter, adding math field breaks visualization
@jangaraj
Thank you for your response. However, I still fail to understand it. So, I can’t reference my fields with “$A” or “$B” because my fields are “A” and “B”, right? Then, how am I supposed to reference them? I tried renaming the fields with a dollar sign upfront, but that didn’t work. How do I actually do what I want in this case? Thanks.
No, your $A*100/$B is Grafana expresion. But don’t use Grafana expression. Use CloudWatch math. CloudWatch math (math calculated by ClouddWatch) != Grafana expression (math, calculated by Grafana), be familiar with these terms:
This still means nothing to me and I don’t know how to apply this to my case. Why isn’t Grafana math working in 10.4 when it worked on version 8?
Got it. Check your (debug) logs and spend time to narrow why expressions are not working based on Grafana server logs/traces (of course read also release notes, breaking changes - blind guess: data format is a problem).
IMHO it’s not worth it to debug why expressions are not working - just use CloudWatch math and you will be safe between any Grafana upgrades, because CloudWatch will be doing whole calculation.
