This article is a Private article. Only a writer and users who know the URL can access it.
Please change open range to public in publish setting if you want to share this article with other users.

More than 5 years have passed since last update.

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

Last updated at 2018-03-05Posted at 2018-03-05

ユーザーの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)

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up