Create Custom Table With custom columns

Avatar
khalid n
  • updated
  • Answered
hi,

i have the following scenario that i want to apply on WeblogExpert :

I have 3 differents links : www.mysite.com/pageid=23 , www.mysite.com/pageid=24, www.mysite.com/pageid=25

and on each link i want to give an alias name : Page23 , Page24 , Page25.

So at the end i want to have a table showing 3 Columns sorted by Hits :

Column 1 = The Alias name
Column 2 = The full Link
Column 3 = Numbers of hits

Is that possible ? if yes, how can i do this ? i tried differents ways but no success.

Thanks
Replies 9
Avatar
0
Michael
It's not possible to show links and aliases in the same row, you can show either alias (by using the modification rules) or link. You can also use grouping in the table, e.g. group links by aliases, but in such case aliases and links will be shown in separate rows similar to the Engines and Phrases report.
Avatar
0
khalid n
Quote from Michael
It's not possible to show links and aliases in the same row, you can show either alias (by using the modification rules) or link. You can also use grouping in the table, e.g. group links by aliases, but in such case aliases and links will be shown in separate rows similar to the Engines and Phrases report.
ok thanks...so now my question is when i choose the filter "Activity by month" in the Main Data option, the month is repeated in all the rows and i have 120 rows. There's a way to hide the month information ? because it's not really a good idea to have the same name of the month repeated 120 times and then present it as a report.
Thanks
Avatar
0
Michael
It seems that you have also specified some data in the "Group by" option. In such case monthly activity is shown separately for each "grouped" data (e.g. file).

What kind of report do you wish to create?
Avatar
0
khalid n
yes i should specify the "Group By" option so my total number of hits will be grouped by the query parameter value : pageid, as mentioned in my first question. And my Main Date option is : "Activity By month" so the number of hits will be based on a specific month. So my report should look like this :

Page     Hits
Page23   2500
Page24   1852
Page25   840

But this is the result i have at the end:

Page     Hits
Page23
Jan 2014   2500
Page24
Jan 2014   1852
Page25
Jan 2014   840

And as you can see the 'Jan 2014' information is displayed on each row, which is embarrassing and i would like to remove.

Do you have some good suggestions to have a cleaner report ? thanks
Avatar
0
Michael
You don't need to use grouped report in this case. The "Activity By Month" main data is only useful if you wish to get monthly statistics for multiple month for each page, for example:

Page Hits
Page23
Jan 2014 2500
Feb 2014 2510
Mar 2014 2520
Page24
Jan 2014 1852
Feb 2014 2510
Mar 2014 2520
Page25
Jan 2014 840
Feb 2014 2510
Mar 2014 2520

However, if you need to show statistics for the whole time range specified in the profile properties (e.g. month), you just need to specify "Main data" in the table properties (e.g. set it to query or file name) and keep the "Group by" field empty.
Avatar
0
khalid n
Oh, i thought i can only use Modification Rules in the "Group By' filter. That's nice that i can do it also in the "Main data". Thank you Michael :)
Avatar
0
khalid n
now i can add "modification rules" in the "Main Data" , how can i use file name with multiple queries in the "modifciation rules" ? In my log file i have both file names and file names with queries. Ex of lines in my log files :
line 10 user_details.asp
line 21 groups_deails.asp gr=root&number=300

so in my modfication rules i added those lines :

user_details.asp = Users Details works
groups_deails.asp gr\=root&number\=300 = Root Group 300 doest work

Can you help me with the second rule ? or there's some documentations of how to do that ?

Thanks
Avatar
0
Michael
If you want to match file names including queries, you need to choose "File name with query" instead of "File name" as main data in the table properties. You also need to write the rules the following way:

user_details.asp = Users Details
groups_deails.asp?gr=root&number=300 = Root Group 30

File names with queries are to be specified with the ? character between file name and query, the same way as such requests are shown in browsers. The \ character before = isn't to be used.

Please also note that modification rules have several modes, you can read about them at http://www.weblogexpert.com/help/wlex... . The one that you use search for inclusion of the specified string. So if string user_details.asp is found in the file name, "Users Details" will be shown.

If you wish ti have more precise control over matching, you can use the wildcard or regular expression rules.
Avatar
0
khalid n
Thanks Michael, You and the WeblogExpert tool rocks!!