Query to use percentage of values

[aprhn]

Hello guys,

I'm beginner in Azure and I started a project in Azure Log Analytics.
I sent different values in a Custom Log from a Logic App (HTTP Request).

I have two values "cpu_used" and "cpu_limit" (Number type) and I want to create a query like :

Display when "cpu_used" is at 80% of "cpu_limit".

I tried many possibilities but I don't understand how to make this.

I don't understand anyway how to works summary percentile().

The value doesn't change.

Thanks you in advance for your advises

Regards,

[#2 · Accepted solution]

@aprhn 

You should be able to do the math with KQL.  This is fake but should give you the idea 

Go to Log Analytics and run query

// example

Perf

| where ObjectName == "Processor" and InstanceName == "_Total"

| project CounterName , CounterValue , Computer

| summarize IdlePct = sumif(CounterValue, CounterName == "% Idle Time" ), UserTime = sumif(CounterValue, CounterName == "% User Time" ) by Computer

| summarize percentage = (sum(UserTime) / sum(IdlePct)) * 100

[#3]

Hello Clive,

Thanks you ! I adapted your query and works fine :).

Regards,

Aurélien