需要显示从Appcenter导出的数据的无崩溃用户 [英] Need to display crash-free users from data, exported from appcenter

问题描述

你好，

我对整个分析工作还是陌生的，所以我希望您能向我提示正确的方向.

I'm fairly new to this whole analytics thing, so i hope you can hint me in the right direction.

我想显示我的应用程序中所有无崩溃的用户，与上个月每天的总用户数进行比较.
因此，我的基本想法是获取每天每个会话没有崩溃的用户数量，获取每天每个会话的所有用户数量，计算百分比并将其显示在漂亮的图表中.

I want to display all crash-free users of my app, compared to the overall amount of users per day over the last month.
So my basic idea is to get the number of users without crashes per session per day, get the number of all users per sessions per day, calculate the percentage and let it be shown in a nice chart.

到目前为止，我发现了如何为所有用户或所有无崩溃用户获得所需的铃声.

So far i found out, how i can get the tings i want either for all users, or for all crash free users.

无崩溃用户:

crashfree users:

customEvents
| where timestamp > ago(30d)
and name != "UnhandledErrorLog" and client_OS contains "Android" and application_Version == 4.1812
| project client_OS, client_Model, customDimensions, user_Id, application_Version 
| extend AppBuild = parsejson(tostring(customDimensions.AppBuild) ) 

总体用户:

overall users:

推荐答案

Maverick

Hi Maverick,

感谢您使用Appliction Insights.为了结婚这两个请求，您可以在日志中使用加入分析查询.你可以

Thank you for using Appliction Insights. In order to marry the two requests you can use Joins in Log Analytics queries. You can

这是您可以使用的示例查询.您可以进一步修改它以适合您的要求:

Here is a sample query that you can make use of. You can further modify it to suit your requirements:

customEvents 
| where timestamp > ago(30d)
and name != "UnhandledErrorLog" and client_OS contains "Android" and application_Version == 4.1812     // crash free
| project client_OS, client_Model, customDimensions, user_Id, session_Id, application_Version
| join kind= inner (
    customEvents 
    | where timestamp > ago(30d)
      and client_OS contains "Android" and application_Version == 4.1812     // all users
    | project user_Id, session_Id
    | summarize CrashFree=dcount(user_Id) by session_Id
    | where CrashFree > 1
) on session_Id
| summarize AllUsers=dcount(user_Id) by session_Id
| where AllUsers > 1

您可以使用一堆聚合，例如count()，avg()等.您可以参考此 文档以获取更多详细信息.

You can use a bunch of aggregations like count(), avg(), etc. You can refer to this document for more details.

这篇关于需要显示从Appcenter导出的数据的无崩溃用户的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！