Here is a query that shows highest average CPU minutes for computer "foo":
| where TimeGenerated > ago(1d)
| where CounterName == "% Processor Time" and InstanceName == "_Total"
| where Computer == "foo"
| summarize avg(CounterValue) by bin(TimeGenerated,1m)
| top 10 by avg_CounterValue
Azure Monitor Logs query example have several examples that also shows CPU data: