topic Re: USQL FUNNEL count clarification in Open Q&A

USQL FUNNEL count clarification

chuan_sern_wong — Thu, 12 Mar 2020 03:05:14 GMT

Hi,

Could anyone from Dynatrace explain how does the USQL Funnel derive the count ? I am experimenting this new USQL FUNNEL function and was trying to match the count but doesn't seem to be tally,

For example, I have 3 user actions ! = /index/login, = !/index/landing and LIKE "!/index/*/create"

here's the USQL statement:

Use COUNT

SELECT useraction.name, COUNT(DISTINCT(usersession.userId)) AS number FROM useraction where useraction.name = "!/index/login" OR useraction.name = '!/index/landing' OR useraction.name LIKE "!/index/*/create" AND errorCount = 0 GROUP BY useraction.name LIMIT 5000

Use FUNNEL:

SELECT FUNNEL(useraction.name = "!/index/login" AS "Login page",useraction.name = '!/index/landing' AS "Landing page",useraction.name LIKE "!/index/*/create") FROM usersession

But the count between COUNT and FUNNEL differ by alot... anyone helpful to share some lights on the difference ? FUNNEL function count is very low and even though I am able to find those user actions via UserSession dashboard but FUNNEL didn't account for it.

Re: USQL FUNNEL count clarification

rastislav_danis — Thu, 12 Mar 2020 10:27:14 GMT

AFAIK, FUNNEL counting is like adding more and more actions that are reached in session for each FUNNEL step. So you should use AND instead of OR in your select to reach similar results as FUNNEL.

Re: USQL FUNNEL count clarification

chuan_sern_wong — Thu, 12 Mar 2020 10:41:33 GMT

OK, thanks for the clarification.

Re: USQL FUNNEL count clarification

Julius_Loman — Thu, 12 Mar 2020 12:25:30 GMT

Actually it honours the order of those user actions, so even with AND you probably won't have the very same results.

For funnel like:
Action1,Action 2,Action 3

If a session has only Action 2 and Action 3 it won't be included in the Funnel as it is mission Action 1.

Re: USQL FUNNEL count clarification

Malaik — Wed, 07 Sep 2022 09:58:41 GMT

I have the same need,

Did you get Any Chance to resolve it.

If yes, how should be the USQL.

Thanks