https://community.dynatrace.com/t5/Real-User-Monitoring/Retrieve-Top-3-Page-groups-using-usql/m-p/202083#M4044 <P>You could leverage the USQL targeting that data such as:&nbsp;</P><P>SELECT COUNT(userevent.pageGroup), userevent.pageGroup FROM usersession WHERE useraction.application IS "&lt;YOURVALUE&gt;" GROUP BY userevent.pageGroup ORDER BY count(userevent.pageGroup) DESC</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ChadTurner_0-1673368230798.png" style="width: 999px;"><img src="https://community.dynatrace.com/t5/image/serverpage/image-id/9352iD2600C84C60ED747/image-size/large?v=v2&amp;px=999" role="button" title="ChadTurner_0-1673368230798.png" alt="ChadTurner_0-1673368230798.png" /></span></P><P>&nbsp;</P> Tue, 10 Jan 2023 16:30:43 GMT ChadTurner 2023-01-10T16:30:43Z https://community.dynatrace.com/t5/Real-User-Monitoring/Retrieve-Top-3-Page-groups-using-usql/m-p/198352#M3968 <P>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.&nbsp;</P><P><SPAN>https://***.live.dynatrace.com/api/v1/userSessionQueryLanguage/table?query=select pageGroup, count(*) from userevent where application ="***" and startTime &gt; $now - duration("24h") group by pageGroup order by count(*) desc &amp;resolution=1m</SPAN></P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Top 3 page groups" style="width: 759px;"><img src="https://community.dynatrace.com/t5/image/serverpage/image-id/8485iB02202FFF6A5D0AE/image-size/large?v=v2&amp;px=999" role="button" title="Screenshot from 2022-11-15 10-08-24.png" alt="Top 3 page groups" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Top 3 page groups</span></span></P><P>&nbsp;</P> Thu, 17 Nov 2022 14:24:20 GMT https://community.dynatrace.com/t5/Real-User-Monitoring/Retrieve-Top-3-Page-groups-using-usql/m-p/198352#M3968 pagiannisg 2022-11-17T14:24:20Z https://community.dynatrace.com/t5/Real-User-Monitoring/Retrieve-Top-3-Page-groups-using-usql/m-p/202083#M4044 <P>You could leverage the USQL targeting that data such as:&nbsp;</P><P>SELECT COUNT(userevent.pageGroup), userevent.pageGroup FROM usersession WHERE useraction.application IS "&lt;YOURVALUE&gt;" GROUP BY userevent.pageGroup ORDER BY count(userevent.pageGroup) DESC</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ChadTurner_0-1673368230798.png" style="width: 999px;"><img src="https://community.dynatrace.com/t5/image/serverpage/image-id/9352iD2600C84C60ED747/image-size/large?v=v2&amp;px=999" role="button" title="ChadTurner_0-1673368230798.png" alt="ChadTurner_0-1673368230798.png" /></span></P><P>&nbsp;</P> Tue, 10 Jan 2023 16:30:43 GMT https://community.dynatrace.com/t5/Real-User-Monitoring/Retrieve-Top-3-Page-groups-using-usql/m-p/202083#M4044 ChadTurner 2023-01-10T16:30:43Z