topic Re: How to get the number of user action for individual application? in Open Q&A

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

Ramanan_16 — Tue, 07 Feb 2023 10:43:23 GMT

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

Re: How to get the number of user action for individual application?

Malaik — Thu, 02 Feb 2023 08:43:00 GMT

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:

Re: How to get the number of user action for individual application?

MichalOlszewski — Fri, 03 Feb 2023 08:53:45 GMT

@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.

Re: How to get the number of user action for individual application?

Ramanan_16 — Sun, 05 Feb 2023 06:23:17 GMT

Hi Malaik,

Yes, it works. Thanks a lot.