De fakto potřebuju spojit dva datasety do jednoho, např:
Dataset "Top User by Bandwidth"
select coalesce(nullifna(
user), nullifna(
unauthuser), ipstr(
srcip)) as user_src, srcip, sum(coalesce(sentbyte, 0)+coalesce(rcvdbyte, 0)) as bandwidth, sum(coalesce(rcvdbyte, 0)) as traffic_in, sum(coalesce(sentbyte, 0)) as traffic_out from $log where $filter and (logflag&1>0) and srcip is not null group by user_src, srcip having sum(coalesce(sentbyte, 0)+coalesce(rcvdbyte, 0))>0 order by bandwidth desc
a do něj zakomponovat i Dataset "Top User App"
select app, coalesce(nullifna(
user), nullifna(
unauthuser), ipstr(
srcip)) as user_src, sum(coalesce(
sentbyte, 0)+coalesce(
rcvdbyte, 0)) as bandwidth from $log where $filter and (logflag&1>0) and nullifna(app) is not null group by app, user_src order by bandwidth desc
aby to ve výsledku vypadalo např. takto