02 Feb 2023
06:25 AM
- last edited on
07 Feb 2023
10:43 AM
by
Ana_Kuzmenchuk
Hi,
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.
02 Feb 2023 08:43 AM
Hello @ram16
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:
05 Feb 2023 06:23 AM
Hi Malaik,
Yes, it works. Thanks a lot.
03 Feb 2023 08:53 AM
Hi
@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.