search

GoshPosh / grafana-meta-queries

Grafana plugin for calculating time period metrics like week over week, month over month and year over year etc.
Apache License 2.0
283 stars 71 forks source link

Adding additional CloudWatch query causes Arithmetic MetaQuery to show "clipped" results #36

Closed matthicks05 closed 4 years ago

matthicks05 commented 6 years ago

I'm successfully using MetaQueries (great feature!) to calculate some DynamoDB cloudwatch metrics by taking a sum of the write_capacity metric and dividing it by 60 using an Arithmetic query.

image

Once I add another CloudWatch query, in this case the "Provisioned Write Capacity", which is essentially a threshold I want to compare the Arithmetic query to, the MetaQuery becomes "clipped".

image

Once I remove Query C, the MetaQuery functions normally once again.

Using (latest) version 0.0.1 of MetaQuery plugin. Using Grafana v5.0.0

Gauravshah commented 6 years ago

Can you plot a table instead of graph with same configuration ? That will give us some idea as to what are the datapoints

On Mon, 24 Sep 2018 at 8:13 PM, matthicks05 notifications@github.com wrote:

I'm successfully using MetaQueries (great feature!) to calculate some DynamoDB cloudwatch metrics by taking a sum of the write_capacity metric and dividing it by 60 using an Arithmetic query.

[image: image] https://user-images.githubusercontent.com/7862124/45958427-08bbc080-bfdd-11e8-8c75-c7d1361cbb0b.png

Once I add another CloudWatch query, in this case the "Provisioned Write Capacity", which is essentially a threshold I want to compare the Arithmetic query to, the MetaQuery becomes "clipped".

[image: image] https://user-images.githubusercontent.com/7862124/45958574-66500d00-bfdd-11e8-898f-5c814930df9a.png

Once I remove Query C, the MetaQuery functions normally once again.

Using (latest) version 0.0.1 of MetaQuery plugin. Using Grafana v5.0.0

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/GoshPosh/grafana-meta-queries/issues/36, or mute the thread https://github.com/notifications/unsubscribe-auth/AAl4DyUAHgCKRoaNdH69WV2qm-TTqfROks5ueO95gaJpZM4W2zKI .

matthicks05 commented 6 years ago

Good idea. I notice the "NaN.00" values when I add the additional Cloudwatch query.

1 Cloudwatch and 1 Arithmetic Query

image

Additional Cloudwatch Query

image

Gauravshah commented 6 years ago

so the NaN is a problem. You might have to do an arithmetic on top of broken metric A['metric_name'] ? A['metric_name'] : 0 something like that