https://community.dynatrace.com/t5/Real-User-Monitoring/How-can-DynaTrace-API-be-used-to-calculate-the-total-duration-of/m-p/116989#M1622 <P>This API is not intended to be used to serve as export of all individual sessions. You should use session export for that. It should be used to retrieve aggregated values or individual sessions.<BR /><BR />Not sure what you are trying to accomplish, but you can use aggregation functions such as avg and group by clause to get meaningul output. For example - get average session duration by country and city:</P><PRE>select avg(duration),city,country from usersession group by country,city<BR /></PRE><BR /> Mon, 15 Apr 2019 18:53:03 GMT Julius_Loman 2019-04-15T18:53:03Z https://community.dynatrace.com/t5/Real-User-Monitoring/How-can-DynaTrace-API-be-used-to-calculate-the-total-duration-of/m-p/116986#M1619 <P>I have been trying the following DynaTrace user session query:</P><P>Select userid, usersessionid from usersession</P><P>adding duration to the above query retrieves the duration for the visually completeness of the useraction.</P><P>May be we can fetch the timestamp for the first useraction in the session and subtract it from the last useraction of the session.</P><BR /> Mon, 15 Apr 2019 10:46:11 GMT https://community.dynatrace.com/t5/Real-User-Monitoring/How-can-DynaTrace-API-be-used-to-calculate-the-total-duration-of/m-p/116986#M1619 dparkar 2019-04-15T10:46:11Z https://community.dynatrace.com/t5/Real-User-Monitoring/How-can-DynaTrace-API-be-used-to-calculate-the-total-duration-of/m-p/116987#M1620 <P>Why are you not using the duration field for usersession? <BR /><BR />You should query the usersession.duration, not the useraction.duration (that will be the selected key metric for user actions).</P><BR /> Mon, 15 Apr 2019 11:05:02 GMT https://community.dynatrace.com/t5/Real-User-Monitoring/How-can-DynaTrace-API-be-used-to-calculate-the-total-duration-of/m-p/116987#M1620 Julius_Loman 2019-04-15T11:05:02Z https://community.dynatrace.com/t5/Real-User-Monitoring/How-can-DynaTrace-API-be-used-to-calculate-the-total-duration-of/m-p/116988#M1621 <P>Thanks Julius that helped</P><P>But I can only retrieve 1000 rows</P><P>Tried adding LIMIT 10000 to the query</P><P>Doesn't help?</P><P>Can you please advise?</P><BR /> Mon, 15 Apr 2019 16:52:49 GMT https://community.dynatrace.com/t5/Real-User-Monitoring/How-can-DynaTrace-API-be-used-to-calculate-the-total-duration-of/m-p/116988#M1621 dparkar 2019-04-15T16:52:49Z https://community.dynatrace.com/t5/Real-User-Monitoring/How-can-DynaTrace-API-be-used-to-calculate-the-total-duration-of/m-p/116989#M1622 <P>This API is not intended to be used to serve as export of all individual sessions. You should use session export for that. It should be used to retrieve aggregated values or individual sessions.<BR /><BR />Not sure what you are trying to accomplish, but you can use aggregation functions such as avg and group by clause to get meaningul output. For example - get average session duration by country and city:</P><PRE>select avg(duration),city,country from usersession group by country,city<BR /></PRE><BR /> Mon, 15 Apr 2019 18:53:03 GMT https://community.dynatrace.com/t5/Real-User-Monitoring/How-can-DynaTrace-API-be-used-to-calculate-the-total-duration-of/m-p/116989#M1622 Julius_Loman 2019-04-15T18:53:03Z