topic Re: USQL - time beetwen steps in Real User Monitoring

USQL - time beetwen steps

MAkimov — Thu, 25 Jun 2020 10:25:06 GMT

Hello

can I calculate the time between two steps in a User session through USQL?

For example, the time from the start of the purchase to payment for the goods?

Re: USQL - time beetwen steps

ChadTurner — Thu, 25 Jun 2020 12:06:44 GMT

You could put in the duration time of action x and make another USQL for action Y. You could also mark the requests as Key request and formulate a chart off of that or even conversion goals

Re: USQL - time beetwen steps

MAkimov — Thu, 25 Jun 2020 12:55:53 GMT

I need a metric not the sum of two steps, but the duration of the period in the session between two steps.

we have a metric for the duration of the session. So I need only part of this metric regarding the two steps of the user in the funnel

Re: USQL - time beetwen steps

JamesKitson — Thu, 25 Jun 2020 14:34:26 GMT

No the only place this is available to any extent is if you're looking at a single user's session where you can see all of the user actions in order but there's no way to get this as a metric or even as number from usql.

With usql you can get start times and end times by querying the user action table but you'd be querying both relevant user actions you can't have data from both of them in the same row. And if you queried from the usersession table you can pull from the useractions but you can't get the starttime from two actions separately, there's just no way to express that.

You'd need to be able to do something like select action1.startTime - action2.startTime as difference from usersession which you cannot do.

Re: USQL - time beetwen steps

MAkimov — Thu, 25 Jun 2020 19:15:56 GMT

pity that there is no such. This is a very useful indicator for business.

maybe I create an RFE. maybe developers will create when not

Re: USQL - time beetwen steps

Saravanakumar_P — Fri, 02 Jul 2021 13:31:31 GMT

Yes. This is very useful information for business, we have useraction.startTime information in the useraction but we are not able to use it wisely for our analysis. Extracting data via USQL API and query the time difference from another tool would not be an ideal way for a single use case(this involves exporting data and requires elasticsearch or an ideal tool in Prod enV).

https://community.dynatrace.com/t5/Dynatrace-product-ideas/USQL-to-find-duration-between-two-steps/idi-p/168660