I was looking for extract the slowest user actions on a certain application where the number of useraction are major of 150 in the timeframe configurated.
Now, I'm using:
SELECT TOP(useraction.name, 10) AS "User Action Name", MEDIAN(useraction.visuallyCompleteTime) AS "Visually Complete Time" FROM useraction WHERE useraction.application IS "app" GROUP BY useraction.name ORDER BY median(useraction.visuallyCompleteTime) DESC
I would like to add the count filter on the result, how can I do it?
Thanks in advantage.
If you want to have info about number of executions for those actions you have to add COUNT(*) in select to see number of executions. Unfortunately we don’t have HAVING command right now or option for making select inside select to have it like this. Only Idea I have is to sum total duration time (not median) of all user actions and sort using this value. In such case, you will see those user actions that takes most time in total (number of executions vs duration)