This post is Private. Only a writer or those who know its URL can access this post.

Azure Application InsightにApp Centerから連続Exportした時の分析クエリ集

More than 1 year has passed since last update.

ユーザーのOSシェアを知りたいとき

union customEvents
| extend OS = iif(client_OS has "iOS" ,"iOS",iif(client_OS has "Android" ,"Android","Other"))
| summarize Users=dcount(user_Id) by OS , bin(timestamp, 1d)
| render piechart 

カスタムイベントのKEY VALUEでサマリーしたいとき

customEvents
| where name != "StartServiceLog" and name != "StartSessionLog"//システムで勝手に生成されるレコードを排除
| summarize count() by tostring(customDimensions.Properties)
Sign up for free and join this conversation.
Sign Up
If you already have a Qiita account log in.