Solved
Estimated Browsing Time
Any report guru's out there tell me how to get the "Estimated Browsing Time" to display by hour or by day rather than for the entire reporting period?
hzhao_FTNTAnswer
Staff
January 19, 2015
There is no predefined chart/dataset for Estimated Browsing Time by hr or by day. You have to create a custom dataset. For example, Estimated Browsing Time by day per user can be written as:
select dom, user_src, sum(browsetime) as browsetime from ###(select $DAY_OF_MONTH as dom, coalesce(nullifna(`user`), nullifna(`unauthuser`), ipstr(`srcip`)) as user_src, sum($browse_time) as browsetime from $log where $filter and logid_to_int(logid) not in (4, 7, 14) group by dom, user_src having sum($browse_time)>0)### t group by dom, user_src order by browsetime desc
