Create Custom Table With custom columns

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
1 person has
this question
+1
Reply
  • 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
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated indifferent, undecided, unconcerned kidding, amused, unsure, silly happy, confident, thankful, excited

  • 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?
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated indifferent, undecided, unconcerned kidding, amused, unsure, silly happy, confident, thankful, excited

  • 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
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated indifferent, undecided, unconcerned kidding, amused, unsure, silly happy, confident, thankful, excited

  • 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.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated indifferent, undecided, unconcerned kidding, amused, unsure, silly happy, confident, thankful, excited

  • 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 :)
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated indifferent, undecided, unconcerned kidding, amused, unsure, silly happy, confident, thankful, excited

  • 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
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated indifferent, undecided, unconcerned kidding, amused, unsure, silly happy, confident, thankful, excited

  • 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.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated indifferent, undecided, unconcerned kidding, amused, unsure, silly happy, confident, thankful, excited

  • Thanks Michael, You and the WeblogExpert tool rocks!!
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated indifferent, undecided, unconcerned kidding, amused, unsure, silly happy, confident, thankful, excited