Action count for and action for a month

[swapnil]

i need to get an count for an action how many time it is called above 1 sec.

select DISTINCT name, count(name) FROM useraction where usersession.applicationType="CUSTOM_APPLICATION" and application="CCX Orders App (V2)" and duration > 1000 GROUP BY name.

Does this query correct becuase if wrote a query with specific action name then the list does not match the count.

[Yosi_Neuman]

Hi @swapnil 

For me the follows works: 

select count(*), name
FROM useraction
where usersession.applicationType = "CUSTOM_APPLICATION"
and application = 'Citrix RUM'
and duration > 100
and name = 'Citrix login'
GROUP BY name

Where do you have problem at your end?

Yos 

[GosiaMurawska]

Hi @swapnil 
Have you managed to solve the problem? It would be great if you shared the solution with the Community users 🙂