Hello. I’m currently trying to do a simple math operation. The operation is to divide 3600 / one of my fields. I’m doing this with the data transformation “Add field from calculation” like this:
The result is normal in most cases but some of them are equal to 0, so the result is equal to infinite. I want to turn the infinite results into 0, but Grafana is not letting me do it thru the value mapping override:
Can someone help me?
Tysm! Also, related to this post, I want to change the color of the fields depending on the ECR (s) value. F.e., every row with more than 6 points should be red, 4-6 should be orange and less than 4 should be green. How can I do this?
Yes! I could not find the “Colored background” option. Tysm!