Business iQ (Analytics)

cancel
Showing results for 
Search instead for 
Did you mean: 

Application Performance Ratio Apdex Index

Reto.Zwyer
Creator

Application Performance Ratio Apdex Index

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

Tags (1)
Application Performance Ratio Apdex Index
1 REPLY 1
Sebastian.Perna
Builder

Re: Application Performance Ratio Apdex Index

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