Kusto calculated field with Metrics

Asked

Viewed 5 times

0

I’m making a query in Kusto on Azure to bring the value of the Redis memory fragmentation, this value is obtained by dividing the RSS memory by the memory used, the problem is that I am not able to do the calculation using these two different fields because it is necessary to filter the value of the field "Average" of the fields "usedmemoryRss" and "usedmemory" when I do the filter in the extend line the query does not return any value, the code is like this:

AzureMetrics
| extend m1 = Average | where MetricName == "usedmemoryRss" and 
| extend m2 = Average | where MetricName == "usedmemory"
| extend teste = m1 / m2

When I remove Where from the lines it divides the value of each record by itself. Is it possible to do that? Thanks in advance for the help.

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.