2018年3月29日 星期四

Azure Application Insights Analytics 簡單分析語法


//所有瀏覽器所佔%數 圓餅圖
pageViews | summarize count() by client_Browser
| extend DurationBucket = tostring(client_Browser)
| project  count_, DurationBucket
| render piechart

//pageViews 瀏覽器統計
pageViews
| summarize count() by bin(duration,20),client_Browser
| extend DurationBucket = tostring(duration)
| project client_Browser, count_
| render piechart

//pageViews 作業系統
pageViews
| summarize count() by bin(duration,20),client_OS
| extend DurationBucket = tostring(duration)
| project client_OS, count_
| render piechart

//pageViews國家
| summarize count() by bin(duration,20),client_CountryOrRegion
| extend DurationBucket = tostring(duration)
| project client_CountryOrRegion, count_
| render piechart



沒有留言:

張貼留言

解決'Microsoft.ACE.OLEDB.12.0' 提供者並未登錄於本機電腦上的問題

  解決'Microsoft.ACE.OLEDB.12.0' 提供者並未登錄於本機電腦上的問題 環境 Server:Windows Server 2012 R2 Debug IDE: VS2019 Step1 確認是否有安裝Microsoft Access Dat...