Queries for the AppPageViews table
For information on using these queries in the Azure portal, see Log Analytics tutorial. For the REST API, see Query.
Page views trend
Chart the page views count, during the last day.
// To create an alert for this query, click '+ New alert rule'
AppPageViews
| where ClientType == 'Browser'
| summarize count_sum = sum(ItemCount) by bin(TimeGenerated,30m), _ResourceId
| render timechart
Slowest pages
What are the 3 slowest pages, and how slow are they?
AppPageViews
| where notempty(DurationMs) and ClientType == 'Browser'
| extend total_duration=DurationMs*ItemCount
| summarize avg_duration=(sum(total_duration)/sum(ItemCount)) by OperationName
| top 3 by avg_duration desc