Azure monitoring

Here is a query you can use to view CPU for computers reporting into Log Analytics.

//CPU Time
Perf
| where CounterName == "% Processor Time"
| summarize CUPTime=avg(CounterValue)  by bin(TimeGenerated, 5m), Computer
| render timechart

Run this from the Logs or Logs(Classic) blade to see the results.  The ComputerName value "% Processor Time" can be replaced by any other value if you want to chart something else.  Be sure these values are added for collection from the Advanced Settings > Data blade in the workspace.

Tiles are used for pre-created views and queries, not for running queries.  Tiles can be added manually or with solutions.  The Security and Compliance solution gives a lot of useful information, it also will enable security log collection.  

If you are looking for more on writing queries, take a look at the Pluralsight Kusto Query Language from Scratch course.  Microsoft's documentation has also improved quite a bit.