Custom Dataset: URL and Category By Hour per user

[RobertReynolds]

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

[RobertReynolds]

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;