How to chart a page group to a dashboard

[soportetr]

Hi everyone,

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

[karthik_a_rao · Accepted solution]

Hello Soportetr,

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'))

Good luck!

Cheers,

Karthik Rao