topic Re: How to calculate Percentage of the Apdex "Frustrated" user's per Application? in Real User Monitoring

How to calculate Percentage of the Apdex "Frustrated" user's per Application?

jmackey — Thu, 14 Apr 2022 13:13:47 GMT

I am trying to create a visual chart using a Honeycomb to plot the percentage of Frustrated users per Application. The idea is to provide a visual for drill down.

I was using Data Explorer and dividing the Frustrated user's by the overall total. Since I cannot use nested SQL, the below is not calculating properly and seems to mix the applications in the division. (I believe because of the sorting). Any ideas or other ways of doing this?

(builtin:apps.web.actionCount.category:filter(and(eq("Apdex category",FRUSTRATED))):splitBy("dt.entity.application"):sum:auto:sort(value(sum,descending)):limit(100))

(builtin:apps.web.actionCount.category:splitBy("dt.entity.application"):sum:auto:sort(value(sum,descending)):limit(100))

Re: How to calculate Percentage of the Apdex "Frustrated" user's per Application?

luislira — Thu, 14 Apr 2022 13:37:20 GMT

Hi @jmackey ,

The metric you are using actually provides you the number of "frustrated"- rated user actions per application. You can calculate the rate using the metric expression that you have, for clarity purposes I'd advise to split it in 3 metrics, one for Frustrated user actions per application, another for Total user actions per application and finally another one for Frustrated user action rate per application. An example below:

Hope this is useful for you!

Re: How to calculate Percentage of the Apdex "Frustrated" user's per Application?

jmackey — Thu, 14 Apr 2022 14:24:48 GMT

Thank you Luislira that worked. I think the reason it did not work originally is I had the "Fold Transformation" set to Sum.

So I'll push my luck with a follow up question. Is there a way to compare this to the average "Frustrated" metric for an Application? Then I go show an alert when it exceeds the normal for the application.

Re: How to calculate Percentage of the Apdex "Frustrated" user's per Application?

luislira — Thu, 14 Apr 2022 15:12:46 GMT

Awesome it worked!

For the Average "Frustrated" metric by application, you can use this metric for example:

builtin:apps.web.apdex.userType.geoBig

and then split by Web Application. I would suggest for a quick and manual comparison to add it as a 4th row in the previous table with your own thresholds set like this:

If you want to alert on the overall Apdex for an application you can set a Custom alert for this metric under Settings > Anomaly Detection > Custom Events for Alerting and create your alert based on a certain Apdex threshold.