01 Feb 2023 10:25 PM - last edited on 07 Feb 2023 02:43 AM by Ana_Kuzmenchuk
I am trying to collect the number of user actions for individual applications. I am trying the below query, but no luck. Any suggestion to achieve this?
SELECT useraction.application, userActionCount FROM usersession WHERE useraction.application IS NOT NULL GROUP BY useraction.application, userActionCount ORDER BY userActionCount DESC
Solved! Go to Solution.
I can understand your question in multiple ways, but let try this:
SELECT application, count(*) as "Number Of Clicks" from useraction GROUP BY application
And the result is:
Yes, it works. Thanks a lot.
@Malaik solution is great as it does it in best possible way. The only improvement I would apply would be changing "Number of Clicks" to "Action count" to avoid misunderstanding as not all actions are technically clicks and not all clicks create action.