Hi, so I need to show something like this:App | sum | Sum of the past 30
days the querie would be something like this:select app, sum(bandwidth),
(sum(bandwidth)/30) from $log where to_timestamp(itime)::date BETWEEN
(current_date) and (current_date-3...
Hi, so I need to do a query that shows the app, user and the kind of
threat. But the app and the user are on the "Traffic" kind log and the
things related to threats are in another kind of log.So is it possible
to join fields from one Log of certain ...
Thanks hzhao_FTNT, Your query really helped me but it seems that's not
working properly when the "today_bandwidth" comes. The result is always
0, the "avg_bandwidth" works fine. When I choose "today" as the time
period it does work on both columns, b...
Hi, I found this thread and I wanna know if you can help me. I need to
do a dataset for a report where show this fields:app | sum(bandwidth) of
today | average of sum(bandwidth) of the last N daysmy query is this
one:[code lang=sql]select t1.app,(sum...
