For SSL VPN (Sorry, can't help with the Proxy one)
On the Analyzer, create new blank report and call it what you want.
Under layout, select "Insert Chart" and select "All VPN Connections"
Then go to Settings, and select "Yesterday" as the time period and specify your device/s
Create a dataset first before creating the chart:
My Dataset contains the following query:
SELECT a.user_src, a.remip, a.user_grp, a.tunneltype, Min(a.login) AS min_login, Max(b.logout) AS max_logout, Max(b.duration) AS max_duration, Max(b.transferred_bytes) AS max_bandwidth, Max(b.sentbyte) AS max_sent, Max(b.rcvdbyte) AS max_rcvd FROM ###(SELECT COALESCE(nullifna(`user`), ipstr(`remip`)) AS user_src, remip, tunneltype, `group` AS user_grp, min(from_dtime(dtime)) AS login, tunnelid FROM $log-event WHERE $filter AND action IN ('tunnel-up', 'tunnel-stats') GROUP BY tunnelid, user_src, remip, user_grp, tunneltype)### a, ###(SELECT max(from_dtime(dtime)) AS logout, duration, sum(sentbyte+rcvdbyte) AS transferred_bytes, sentbyte, rcvdbyte, tunnelid FROM $log-event WHERE $filter AND action IN ('tunnel-down', 'tunnel-stats') GROUP BY tunnelid, duration, sentbyte, rcvdbyte HAVING sum(sentbyte+rcvdbyte)>0)### b WHERE a.tunnelid=b.tunnelid GROUP BY a.tunnelid, a.user_src, a.remip, a.user_grp, a.tunneltype ORDER BY min_login, a.user_src
Then create the chart and select the dataset you created (Another screenshot to follow for column 5 and 6)
Sorry about all the replies, not sure how to add multiple screenshots in one post...
