Skip to main content
RobertReynolds
RobertReynolds
New Member
March 23, 2017
Question

Custom Dataset: URL and Category By Hour per user

  • March 23, 2017
  • 1 reply
  • 3399 views

I am trying to modify the "web-hourly category and website hits" dataset so that I can list some specific time periods to run on a per-user basis to get all their URL and Category hits for that timeframe

 

eg: 08:20 - 08:55, User, URL, Category.

Could anyone help me out please?

 

Many thanks.

 

Robert

    1 reply

    RobertReynolds
    RobertReynoldsAuthor
    New Member
    July 24, 2017

    Here is what I ended up using, just in case this can help anyone else:

     

    select hostname, url, catdesc,  to_char(from_dtime("dtime"), 'HH24:MI' ) as hour from $log where $filter  and  to_char(from_dtime("dtime"), 'HH24:MI') between '8:20'  and '08:55' and hostname is not null order by hour;

    Terms & ConditionsAccessibility statement