Apdex rating for entry actions using usql

Pranjal17 — Mon, 07 Apr 2025 08:51:13 GMT

Hi ,
if anyone could help me with this :

want to fetch the data given here using usql .

Thanks in advance .

Re: Apdex rating for entry actions using usql

rastislav_danis — Mon, 07 Apr 2025 13:14:28 GMT

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

topic Apdex rating for entry actions using usql in Open Q&A

Apdex rating for entry actions using usql

Re: Apdex rating for entry actions using usql