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

USQL - time beetwen steps

MAkimov
Mentor

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?


5 REPLIES 5

ChadTurner
DynaMight Guru
DynaMight Guru

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


-Chad

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

JamesKitson
Dynatrace Leader
Dynatrace Leader

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.

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

Saravanakumar_P
Participant

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/i...