24 Mar 202111:33 PM - edited 24 Mar 202111:37 PM
I am trying to create a table of selected key user actions with a filter based on their name. However, whatever I try to use as filter on useraction.name, the result set contains more results than the desired selection. No matter if I use useraction.name IN, IS, =, STARTWITH or LIKE.
SELECT useraction.name, AVG(useraction.visuallyCompleteTime) AS VCT FROM usersession WHERE useraction.application='APPNAME1' AND browserType='Desktop Browser' AND useraction.targetUrl STARTSWITH "https://my.site" AND useraction.name IN ("my - some page") GROUP BY useraction.name ORDER BY useraction.name DESC
Other selections that appear not to have a result are useraction.keyUserAction IS true and useraction.internalKeyUserActionId STARTSWITH "APPL"
Example of query result, with expected results in green box:
Thanks to Collin of support I was pointed out that I needed to reverse my query, using useraction not usersession, and pull the session variables from usersession.<var>, thus:
SELECT useraction.name, AVG(usersession.visuallyCompleteTime) AS VCT FROM useraction WHERE useraction.application='APPNAME1' AND usersession.browserType='Desktop Browser' AND usersession.targetUrl STARTSWITH "https://my.site" AND useraction.name IN ("my - some page") GROUP BY useraction.name ORDER BY useraction.name DESC