FortiAnalyzer custom reporting feature

[kavehfortinet2018]

Dear all

Is it possible to do the below reports with forti analyzer ?

Combine reports and consolidate reports ( such as user browsing activity during  working hours ( 9am  to 1pm) and non-working hours (1pm to 2pm , 6pm to 9am) daily , weekly and monthly  )including top 50 user, top 50 web sites users visit . total bandwidth used by users.Is it possible to have scheduled reports like during certain duration (1 pm to 2pm) ? 

Regards

[RobertReynolds]

This dataset will give you the web browsing time of day results:

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 '9:00'  and '13:00' and hostname is not null order by hour;

I've not figured out how to have different time periods in the same report as that parameter is set on the report setting itself. Interested to hear if it can be done, as Ive had a lot of requests for showing 'trends' over time.