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

Retrieve Top 3 Page groups using usql

pagiannisg
Visitor

Hello, I am trying to retrieve information about the top 3 page groups as shown in the application dashboard (attached image) using usql and I am having trouble with the resolution. I can't match the values I get through the API with what I see on the dashboard. 

https://***.live.dynatrace.com/api/v1/userSessionQueryLanguage/table?query=select pageGroup, count(*) from userevent where application ="***" and startTime > $now - duration("24h") group by pageGroup order by count(*) desc &resolution=1m

 

Top 3 page groupsTop 3 page groups

 

1 REPLY 1

ChadTurner
DynaMight Legend
DynaMight Legend

You could leverage the USQL targeting that data such as: 

SELECT COUNT(userevent.pageGroup), userevent.pageGroup FROM usersession WHERE useraction.application IS "<YOURVALUE>" GROUP BY userevent.pageGroup ORDER BY count(userevent.pageGroup) DESC

ChadTurner_0-1673368230798.png

 

-Chad

Featured Posts