Need USQL for apdex score calculation

[amita]

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

[gbaudart · Accepted solution]

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.

[amita · Accepted solution]

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

[gbaudart]

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))"

[gbaudart]

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

[amita]

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

Thanks for the suggestion 🙂

[gbaudart]

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.