Skip to main content
vachtang
vachtang
New Member
March 12, 2015
Solved

Custom report filtered by web page. How to?

  • March 12, 2015
  • 1 reply
  • 5319 views

Hi,

 

I need to create custom report with template filter for web page.

Behavior similar like in "User Detailed browser" reports, but filtering nor by user, but by web page.

 

Report example:

 

www.webpage.com

User1      time1      Bandwidth1

User2      time2      Bandwidth2

User3      time3      Bandwidth3

User4      time4      Bandwidth4

 

How can I create this report?

is it possiible? :)

 

Thank you

    Best answer by hzhao_FTNT

    Hi, it is not possible for user to create filter under configuration, this has to be hard-coded.

     

    vachtang wrote:

    Thank you, is it possible to create filter in report "Configuration" tab, like in "Detailed user report" reports?

     

     

    1 reply

    hzhao_FTNT
    Staff
    hzhao_FTNT
    Staff
    March 12, 2015

    Hi there,

     

     

    You need a custom dataset like: 

    select hostname, user_src, sum(delta) as browsetime, sum(bandwidth) as bandwidth from ###(select hostname, coalesce(nullifna(`user`), ipstr(`srcip`)) as user_src, sum($browse_time) as delta, sum(coalesce(sentbyte, 0)+coalesce(rcvdbyte, 0)) as bandwidth from $log where $filter group by hostname, user_src having sum($browse_time)>0 order by delta desc)### t group by hostname, user_src order by browsetime desc

    The log type is traffic. Then you can create a custom chart based on this dataset, add this chart to a new report. Before report running, you have to add a hostname filter in advanced setting.

     

    Regards,

    hz

    vachtang
    vachtangAuthor
    New Member
    March 13, 2015

    Thank you, is it possible to create filter in report "Configuration" tab, like in "Detailed user report" reports?

     

     

    hzhao_FTNT wrote:

    Hi there,

     

     

    You need a custom dataset like: 

    select hostname, user_src, sum(delta) as browsetime, sum(bandwidth) as bandwidth from ###(select hostname, coalesce(nullifna(`user`), ipstr(`srcip`)) as user_src, sum($browse_time) as delta, sum(coalesce(sentbyte, 0)+coalesce(rcvdbyte, 0)) as bandwidth from $log where $filter group by hostname, user_src having sum($browse_time)>0 order by delta desc)### t group by hostname, user_src order by browsetime desc

    The log type is traffic. Then you can create a custom chart based on this dataset, add this chart to a new report. Before report running, you have to add a hostname filter in advanced setting.

     

    Regards,

    hz

    hzhao_FTNT
    Staff
    hzhao_FTNTAnswer
    Staff
    March 13, 2015

    Hi, it is not possible for user to create filter under configuration, this has to be hard-coded.

     

    vachtang wrote:

    Thank you, is it possible to create filter in report "Configuration" tab, like in "Detailed user report" reports?

     

     

    Terms & ConditionsAccessibility statement