topic Re: USQL - Segment Funnel Chart by Apdex Score of User Action in Funnel in Dashboarding

USQL - Segment Funnel Chart by Apdex Score of User Action in Funnel

A59Q7ZZ — Fri, 10 Jul 2020 13:35:35 GMT

I'd like to create a funnel chart segmented by the apdexCategory of a specific user action within that funnel. The general question I'm trying to answer is, "How does the user experience with our site's Product Details Pages impact Add to Cart and Place Order rates?" I have the following USQL statement that attempts to create the segment for Frustrated "loading of pdp (/d/)" user actions in the WHERE clause (in bold below), but it's clearly not bringing back the correct numbers:

SELECT FUNNEL(
useraction.name = "loading of pdp (/d/)" AS "Product Details Page", <-- Want only FRUSTRATED PDP actions
useraction.name = "ajax call for add to cart" AS "Add to Cart Action",
useraction.name = "ajax call for place order" AS "Order Placed")
FROM usersession
WHERE userType = "REAL_USER" AND (useraction.name = "loading of pdp (/d/)" AND useraction.apdexCategory = "FRUSTRATED")

i'd like the useraction.apdexCategory = "FRUSTATED" part to refer specifically to the "loading of pdp (/d/)" user action, but i'm pretty sure it's not doing that. I probably need something more like...

WHERE useraction(name, apdexCategory) = ("loading of pdp (/d/)", "FRUSTRATED")

...but that syntax obviously doesn't work. Does anyone know if such a query is possible?

Re: USQL - Segment Funnel Chart by Apdex Score of User Action in Funnel

JamesKitson — Fri, 10 Jul 2020 14:47:29 GMT

Your query is filtering down to sessions that have any frustrated user actions as you suspect. I don't see a way to do what you're looking for right now, it might need something like subqueries but nothing like that is in USQL right now.

It's a great idea though, I'd look at posting an idea/rfe.

Re: USQL - Segment Funnel Chart by Apdex Score of User Action in Funnel

A59Q7ZZ — Mon, 16 Oct 2023 14:24:51 GMT

Thanks, James - appreciate the confirmation that I'm not just missing something obvious.

Idea posted: https://community.dynatrace.com/idea/241852/view.html