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

Ramanan Raghunathan
3 REPLIES 3

Malaik
Champion

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.

Ramanan Raghunathan

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.

Featured Posts