I am trying to plot ALB availability using following formula
Availability % = (RequestCount - HttpCode_ELB_5xx_Count) / RequestCount
I could easily get Requestcount and HttpCode_ELB_5xx_Count queries. However, I am not able to get ahead with calculations part. I am aware of transformations. I added “Add Field from Calculations” it is not giving any values in graph. Neither subtraction nor division.
Thanks for your response,. Yes, I ended up with adding custom metrics and plotting it in grafana. I wish grafana has inbuilt support to do simple math on queries and also have alerting capabilities on those queries.