browsetime dataset problem

Forum|Forum|9 years ago
December 22, 2016
1 reply
3866 views

Hello, I have the following dataset which returns the bandwidth and browsetime of users who visit social media websites.

This report works perfectly when I run the 'test' feature within the dataset, however as soon as I place it in to a report, the output results are distorted i.e. browsetimes should as only 1 or 2 seconds.

Can anyone confirm if this dataset is structured correctly (even though it does work via 'test' in the dataset panel).

Dataset attached to this post.

datasest.txt

Best answer by hzhao_FTNT

Hi there, bandwidth need to be aggregated in main query, try:

select user_src, sum(bandwidth) as bandwidth, ebtr_value(ebtr_agg_flat(browsetime), null, $timespan) as browsetime from ###(select user_src, sum(bandwidth) as bandwidth, ebtr_agg_flat(browsetime) as browsetime from (select coalesce(nullifna(`user`), ipstr(`srcip`)) as user_src, ebtr_agg_flat($browse_time) as browsetime, sum(coalesce(sentbyte, 0)+coalesce(rcvdbyte, 0)) as bandwidth from $log where $filter and $browse_time is not null and (catdesc = 'Social Networking' or catdesc = 'Shopping' or catdesc = 'Games') group by user_src) t group by user_src order by ebtr_value(ebtr_agg_flat(browsetime), null, $timespan) desc)### t group by user_src order by browsetime desc

regards,

hz

hzhao_FTNTAnswer

Staff

Hi there, bandwidth need to be aggregated in main query, try:

select user_src, sum(bandwidth) as bandwidth, ebtr_value(ebtr_agg_flat(browsetime), null, $timespan) as browsetime from ###(select user_src, sum(bandwidth) as bandwidth, ebtr_agg_flat(browsetime) as browsetime from (select coalesce(nullifna(`user`), ipstr(`srcip`)) as user_src, ebtr_agg_flat($browse_time) as browsetime, sum(coalesce(sentbyte, 0)+coalesce(rcvdbyte, 0)) as bandwidth from $log where $filter and $browse_time is not null and (catdesc = 'Social Networking' or catdesc = 'Shopping' or catdesc = 'Games') group by user_src) t group by user_src order by ebtr_value(ebtr_agg_flat(browsetime), null, $timespan) desc)### t group by user_src order by browsetime desc

regards,

hz

Sign up

Login with SSO

Login to the community

Login with SSO