How to get the number of user actions for an individual application?

[Ramanan_16]

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

[Malaik · Accepted solution]

Hello @Ramanan_16 

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:

[Ramanan_16]

Hi Malaik,

Yes, it works. Thanks a lot.

[MichalOlszewski]

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.