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
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
Featured Posts
