Apdex rating for entry actions using usql

[Pranjal17]

Hi ,
if anyone could help me with this :

want to fetch the data given here using usql .

Thanks in advance .

[rastislav_danis · Accepted solution]

Hi, usql alone will not do the job fully, but you can extract apdexcategory data for timeslots (in this usql it's 5 minute slot) for entry actions and then count externally via apdex formula (https://en.wikipedia.org/wiki/Apdex) for each slot:

SELECT DATETIME(startTime, "yyyy-MM-dd hh:mm", "5m") AS time, apdexCategory, COUNT(apdexCategory) FROM useraction WHERE application IS "yourappname" AND isEntryAction IS true group by time, apdexCategory ORDER BY time ASC