How can I group number of visits based on a part of user name?

Avatar
Ibrahim
  • updated
  • Answered
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
Replies 2
Avatar
0
Ibrahim
Thanks Michael,

Works great.

Cheers,
Ib
Avatar
0
Michael
If the logins are logged as usual usernames (and are shown in the "Authenticated Users" report now), you can get information on companies using custom tables.

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...

Customer support portal powered by UserEcho