topic Re: Need USQL for apdex score calculation in Real User Monitoring

USQL for Apdex score calculation

amita — Fri, 10 May 2024 14:38:38 GMT

Hello,

I want an output of USQL like below,

apdex category is available with USQL(Satisfied,frustated,tolerating).Not able to get score using the same
Can someone please help on this?

Regards

Amita

Re: Need USQL for apdex score calculation

gbaudart — Mon, 15 Apr 2024 13:28:09 GMT

Hi @amita
You can view this list of applications with the corresponding Apdex score in the Data Explorer, not in USQL.
Select the metric: "Apdex (by geolocation, user type)[web]", split by "web application".
If you choose the "Table" view, you'll get the table you're looking for, which you can add to a dashboard.

Re: Need USQL for apdex score calculation

amita — Mon, 15 Apr 2024 14:14:47 GMT

Hello @gbaudart ,

I have tried this one earlier and it was giving me the expected result .

However I want to automate the process of getting apdex data at specific interval .

So was trying it over javascript calling usql in it. I have also tried calling an API but the results were not matching with dashboard one.

Thanks for quick response

Re: Need USQL for apdex score calculation

gbaudart — Mon, 15 Apr 2024 14:55:46 GMT

This is not possible in USQL.
However, you should be able to use the APIs to retrieve information from the following DataExplorer request: "builtin:apps.web.apdex.userType.geoBig:splitBy("dt.entity.application"):sort(value(auto,descending))"

Re: Need USQL for apdex score calculation

gbaudart — Mon, 15 Apr 2024 14:56:06 GMT

Alternatively, you could consider using workflows (or SRGs) to retrieve information every 15 minutes, for example.

Re: Need USQL for apdex score calculation

amita — Tue, 16 Apr 2024 06:17:55 GMT

yes,once we are able to retrive ,use of SRG and workflow is in our plan.

Thanks for the suggestion 🙂

Re: Need USQL for apdex score calculation

gbaudart — Tue, 16 Apr 2024 07:42:36 GMT

If you look at the information in USQL, you'll see a difference to DataExplorer.
DataExplorer's metrics are real-time and cover all application actions.
USQL only allows you to process information from user sessions that have ended. So if you look at a USQL from the last hour, for example, it's unlikely to be representative. (And depending on how your application works, the current day's display in the USQL may be heavily biased).
Where possible, I always prefer to get information from the DataExplorer.