Application Performance Ratio Apdex Index

[Reto.Zwyer]

Hi 

I would like to setup a query to reflect the ApDex Index of an application performance.

https://en.wikipedia.org/wiki/Apdex#:~:text=Apdex%20(Application%20Performance%20Index)%20is,measure....

i am not able to translate the docu into a proper query - any idea  ?

• SELECT sum((count(userExperience=Normal)+ count(userExperience=NORMAL)+count(userExperience=SLOW))* 0.5+ count(count(userExperience=VERY SLOW)+count(userExperience=Stall))/count(userExperience)
• FROM transactions WHERE application = "appname"

BR, Reto

[Sebastian.Perna]

I found kind of a solution with this query:

SELECT 100.0 * filter(count(*), userExperience != "ERROR") / count(*) FROM transactions WHERE application = "application" SINCE 1 minutes

This gives me the ratio in % of the completed transactions. But in my case still it isn't what i am looking for

[Ashmita.Thapar]

Hi @Sebastian.Perna,

Is it possible to request the time series data of this query via API? Any useful reference can help