I have the following requirement:
A customer need how many users access to a diferent product on the application , e.g:
/product/prod1, /product/prod2, /product/prod3, etc
Is it possible to do this through USQL?
Thanks in advance
Solved! Go to Solution.
12 Mar 2023 12:23 AM - last edited on 28 Mar 2023 03:56 AM by MaciejNeumann
You can build your USQL something like this:
- Here I have filtered session from 2 apps: easyTravel Demo and www.easytravel.com. You can put the application in interest.
- The sessions with users hitting specific page-group can be accomplished using "userevent.pageGroup" option as shown below:
SELECT * FROM usersession WHERE ((useraction.application IN ('easyTravel Demo', 'www.easytravel.com') OR userevent.application IN ('easyTravel Demo', 'www.easytravel.com') OR usererror.application IN ('easyTravel Demo', 'www.easytravel.com')) AND userevent.pageGroup IN ('/special-offers.jsp', '/orange.jsf', '/privacy-orange.jsf'))