cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

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

ram16
Helper

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

3 REPLIES 3

Malaik
DynaMight Pro
DynaMight Pro

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:

Malaik_0-1675327246918.png

 

Sharing Knowledge

Hi Malaik,

Yes, it works. Thanks a lot.

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.