LoginSignup

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.

@07JP27

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

Last updated at Posted 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)
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
Sign upLogin