How can I group number of visits based on a part of user name?
My application users use their corporate email address to login to my application. How can get WebLog Expert to group on the domain name after @ in the user name?
Example:
username: user1@company1.com.
I need to group the visits based on company1.com
Would that be possible in a custom table? If yes, what is the correct syntax for the expression?
Thanks,
Ib
Example:
username: user1@company1.com.
I need to group the visits based on company1.com
Would that be possible in a custom table? If yes, what is the correct syntax for the expression?
Thanks,
Ib
To do it, create a new custom table in Options > Report > Tables, and choose "User name" as main data. Click the "Custom..." button to the right of the "Main data" combo box, enable the modification rules and enter the following rule:
.*@(.+) ~= \1
You can find more information on the modification rules at http://www.weblogexpert.com/help/wlex...