Skip to main content
trubble
trubble
New Member
January 19, 2015
Solved

Estimated Browsing Time

  • January 19, 2015
  • 4 replies
  • 7402 views

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? 

    Best answer by hzhao_FTNT

    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

    4 replies

    hzhao_FTNT
    Staff
    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

    trubble
    trubbleAuthor
    New Member
    January 19, 2015

    I'm having trouble with the query.  Bear with me as I am not a sql guy.

     

    Running a test on this query in the dataset, I am getting the following error:

     

    ERROR:  column "ebtime" does not exist
    LINE 1: ...user"), ipstr("srcip")) as user_src, sum(coalesce(ebtime, 0).
    hzhao_FTNT
    Staff
    hzhao_FTNT
    Staff
    January 19, 2015

    What's your FAZ version? Did you set log type to traffic?

    trubble
    trubbleAuthor
    New Member
    January 19, 2015

    I tried both traffic and web filter.  v5.2.1-build0662

     

     

     

     

    trubble
    trubbleAuthor
    New Member
    January 19, 2015

    Nevermind!  Not sure what I did differently but after relogging it's working like a charm.  Thanks for your help!

    Terms & ConditionsAccessibility statement